Automatic backup of datatype to google sheets

Need help APIs
1

Hey all,

I’m looking to set up an automated system where all data for a particular datatype is backed up into Google Sheets once per month. There will be about 1000 things per month to back up.

I currently have a google sheet with all the correct headings matching the fields in my datatype.

As far as I understand, I’ll need to use Google Sheets API, and backend workflows. I can’t find a simple step-by-step guide for doing this. Would really appreciate any help that could be offered.

Alternatively, if it’s simpler to automate a csv backup of my datatype, and upload to google sheets automatically, that would also work fine. As opposed to continuously updating the same sheet (if that makes sense).

Thanks!

2

Here are the high-level steps:

  1. Use the API Connector to set up your Google Sheets API call and test out writing from your data type to a sheet
  2. Create a new backend API workflow. This will:
    A. Do a search for the data type, fetching all rows since the last backup (or all the rows if you want a full back up.
    B. Call the Google Sheets API to write the data
    C. Schedule itself to run again at Current date/time:+ months: 1
  3. Optionally, you can create a new API Job thing in your database and create a new one with the ID that step C will return. That is purely for cancelling the recursive job later if you need to.
  4. You can also optionally add a step to send you an email if the Google API returns an error.
3

Thank you! I will give this a try.

Legend!

1 Like