Import feedback from CSV/XLS via Google Sheets
Prodsight supports a variety of popular data sources including Intercom, Zendesk and over 2,000 apps via Zapier.
If you want to import data to Prodsight from an unsupported data source or a CSV or XLS file, then our Google Sheets integration might offer a solution.
- An active Prodsight account
- A Google account with access to Google Sheets
How does it work?
1. Request access to our template
Our Google Sheets integration is in beta so please contact us for access. We will share secure access to our Google Sheet importing template with you.
2. Familiarize with the data structure
The Google Sheet contains two system worksheets:
- Preparation - a worksheet for preparing your data
- IMPORT - a worksheet for importing your data into Prodsight
You can add or import additional worksheets to the document for your data cleaning/preparation needs.
Important: do not remove or rename the existing worksheets - otherwise, the integration will not work.
The template maps to the following Prodsight metadata fields.
|Message Text||Yes||The body of the message you wish to import||Your app is great!|
|Message Created Date||Yes||When the message was created||2021-01-01|
|Data Source||Yes||Where the message originated||Typeform|
|Message ID||The unique identifier of the message within the Data Source||32543|
|Conversation ID||If a message is part of a thread, you can specify the unique identifier of the thread within the Data Source||235324|
|Conversation URL||The URL where the message can be accessed within your Data Source||https://typeform.com/survey/235324|
|Conversation Created Data||If a message is part of a thread, the date when the thread was created||2021-01-01|
|Author ID||If a message is associated with a user, the unique ID of the user within your Data Source||343|
3. Prepare your data
First, you need to prepare your data by mapping it to the Prodsight template structure.
- Open the Google Sheet we shared with you
- Select the worksheet titled Preparation
- Paste your data into the Preparation worksheet
- Make sure that each row maps to the correct columns as illustrated below.
4. Copy data over for importing
Once you are happy with how the data looks in your Preparation sheet, please follow these steps:
- Open the Preparation worksheet
- Select all the rows and columns you wish to import
- Copy your selection (you can use shortcuts CMD+C (Mac) or CTRL+C (Windows))
- Open the IMPORT worksheet
- Scroll to the last populated row in the worksheet
- Paste your selection (you can use shortcuts CMD+V (Mac) or CTRL+V (Windows))
- You will be asked to confirm the action, click OK to proceed
- Your rows are now pasted
- The new rows will be automatically picked up and imported into your Prodsight workspace within 5-10 minutes.
PLEASE NOTE: Always paste the data as new rows. Never overwrite existing rows as the integration only looks for new rows when deciding what to import.