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
Zoho to BigQuery historic data import
Best answer by ForYourITBest answer by ForYourIT
Hi
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!
~Bjorn
1 person likes this
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+7- Tinkerer
- 259 replies
- Answer
Hi
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!
~Bjorn
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.