Hello! Sorry it took me a few days to get back to this. I started experimenting and was able to push my Google Sheet rows to a Coda table. My adventures in trying to get all the auto-generated sheets to push to one
master sheet/tab hasn’tt worked out but I’m contacting Zapier to see if they have any suggestions.
As far as I can tell, my only option is to get the Google Sheet option to work. It’s a pretty simple setup for my colleague who will be responsible for replicating the JotForm template. It’d be too much to have her setup each form to be pushed through Zapier/Integromat to the common Coda table (since there isn’t a direct Coda to JotForm integration. I don’t think you can push directly to Coda in any way…?).
I’m still trying to figure this out. My next attempt was to get each JotForm to create a new spreadsheet in a specific folder then try to pull it into a master spreadsheet that could then be pulled into Coda. JotForm won’t let me select the Drive subfolder when creating a new form, so that didn’t pan out.
I’m still hopeful to work out the logistics of this case!