DataTools Pro + Google Sheets
Upsert metrics in DataTools Pro for new or updated rows in Google Sheets
Stay on top of your data with this workflow. Whenever a new or updated row is detected in your Google Sheets, it swiftly updates the metrics in your DataTools Pro. It’s a time-saving solution for keeping your records current and accurate — no manual data entry required, it's an effortless process. Perfect for those regularly working with large data sets.
Stay on top of your data with this workflow. Whenever a new or updated row is detected in your Google Sheets, it swiftly updates the metrics in your DataTools Pro. It’s a time-saving solution for keeping your records current and accurate — no manual data entry required, it's an effortless process. Perfect for those regularly working with large data sets.
- When this happens...New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
- automatically do this!Save or Update Metric
Creates a new metric or updates an existing one using metric_id. Includes logic and alias management.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
