I am working on a Zoho to BigQuery integration/zap.
It seems that only new data added to Zoho following the zap’s activation can be imported.
Does anybody know how to retroactively run a zap on historic data in Zoho?
Best answer by ForYourIT
Yes, Zapier only supports the data being added after the time the Zap workflow got activated. However, you can use a “workaround” with some small manual work to get it done.
What you can do:
- Create a Zap workflow which parses CSV data to Bigquery
- Export whatever Zoho data you want to have in a CSV
- Upload the CSV to a google drive folder
- Use the Zap explained above to transfer the data to BigQuery
Hope this helps you!