Best answer

Zoho to BigQuery historic data import

  • 23 August 2020
  • 1 reply
  • 34 views

Userlevel 1

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? 

icon

Best answer by ForYourIT 24 August 2020, 12:05

Hi @img ,

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

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +7

Hi @img ,

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