Many of our customers use Google Sheets to capture, organize and store various types of customer feedback. Appbot offers natural language processing and sentiment analysis for Google Sheets, so you can analyze any feedback data you have in Google Sheets alongside your app reviews, support tickets and any customer feedback you import into Appbot.
Connecting one or more Google Sheets to Appbot will mean any feedback you store in Google Sheets is automatically imported into Appbot. Once you have set up your Google Sheet as a source in Appbot you’ll be able to:
- see Sentiment trends over time
- instantly see which words are most common in your Google Sheet
- group your Google Sheets data by Topics, Tags and Custom Topics
- view Google Sheets data as a stand-alone data source, or report on it as part of your overall Voice of the Customer program
You’ll need an Appbot Large plan (paid or trial version) or higher to use Appbot’s sentiment analysis for Google sheets.
How to import Google Sheets spreadsheet rows into Appbot:
- Head to the Manage Sources page and click ‘Add New Source’
- Select ‘Google Sheets’
- Link your account
- Choose your Google account(You can use any Google account with access to the spreadsheet you’d like to import. If you use GSuite then we recommend creating and using an account specifically for Appbot.)
- Click ‘Allow’ so Appbot can read your sheets
- Paste your Google spreadsheet (ID or URL), then click ‘Next’
- Give the source a name and select the sheet to extract data from (i.e. the tab in the Google Spreadsheet)
- We will process each row in the spreadsheet, so tell us if the sheet has a header row so we can skip it
- Tell us which columns to map to which field in Appbot
- Check the preview, then click ‘Create Custom Source’
- All done! You’ve connected your Google Sheets spreadsheet to Appbot.
- Click the new source name and you will see your Google Sheets data looking something like the example below!
If you need any further assistance on setting up the Appbot Google Sheets integration, don’t hesitate to contact us at firstname.lastname@example.org with any questions. We would love your feedback on this new feature!