Guide: Tenzo Data Importer (Google Sheets: Social)
How do core concepts map to Tenzo?
Key: ✅ Supported 🚸 Work in Progress ❌ Not supported
 |
|
|---|---|
| Location | ✅ Location |
| Review | ✅ Review |
| Source | ✅ Source |
| Rating | ✅ Rating |
Data Ingestion
| Real-time optionally available? | ❌ |
| Default polling frequency | Every 6 hours |
| Data retrieved on each poll | All data in the spreadsheet |
| Historical data | All data you input into the sheet |
How do I connect this data to Tenzo?
GoogleSheets can be connected directly inside of the Tenzo app.
This is the template you should be using. Please contact your Customer Success Manager and they will make a copy of this template and connect it for you.
How do I populate the template?
Please head to the last tab in the sheet, called "Social". Here you can add Source of the Review, Comment, Rating.
Please note that for the template to work, dates need to be in the same formatting you find at the top of the template, YYYY-MM-DD:
You should delete all other tabs in the sheet that are not needed.
How do I compare Google Sheets data to data in Tenzo?
In Tenzo, Navigate to Social > Activity:
Compare the reviews you find here with the ones in your Google Sheet. You can use Tenzo's search bar if you want to find a specific review.
These reviews will not appear in the dropdown, nor will they be visible when breaking down by "Source", but can be seen in Social Cards (for example this) alongside all other reviews.
Exceptions
None