I have a data table in a google sheet that I would like pulled into a coda table regularly vs copy and pasting. Ideally this happens every hour or so. I’ve searched throughout the forum, but no one seems to have a solution to replace the “copy and pasting” from Sheets. There are allusions to it, but I can’t find a single example of this being set up with Zapier.
What I’ve tried?
Setting up a “Get Many Spreadsheet Rows” Zap that pulls the spreadsheet in and then sends it to Coda.
Why doesn’t this work?
The data exported from that block seems to be in array form and inaccessible on a per field basis (ie I can’t do something like
data.field_name to access one of the columns - it’s just a giant array of spreadsheet rows and gets plopped in a single Coda cell as a comma-separated list
Why can’t I just setup triggers for each row?
Because the data in the spreadsheet changes within existing rows all the time. I have about 20 cells I need to import and don’t want to create 20 zaps. I just want to pull the sheet in each our and do a lookup within Coda instead.
Anyone have any suggestions? Would really appreciate the help! I’m sure others need to do this as well - maybe I’m just missing something.