Export data from DOMO to Google Sheets on Schedule

Hello!

I imported data from Snowflake using federated dataset to DOMO. Now I wish I can export this dataset to Google Sheets. I've tried Add-on, it partially works but it can't automatically run on schedule. I've also tried to use Magic ETL to writeback data but I can't get access to the API so it doesn't work. Can anybody please give me some advice on exporting data to Google Sheet on a scheduled task?

Answers

  • You can reach out to your CSM to enable the Google Sheets Writeback connector. There is a cost associated. If you are on the consumption model of Domo then it is free to use but you'll still need to reach out to your CSM.

    If I solved your problem, please select "yes" above

  • Thank you Colemen! Will try to contact PIC to figure out. Meanwhile I found that we can create a card and then set a "scheduled report", at the same time send the raw dataset within the report by email, and this somehow works (though not the idealist way)