Google Sheet - Coda Sync

1

I need to do a one way sync from Google Sheets to Coda and am using the google app script to complete this (How to sync data from Coda to Google Sheets (and vice versa) with Google Apps Script tutorial).

The source file (google sheet) has 8 columns and 2600 rows. New rows are added daily (about 200 a day). I am able to get the script to work, except the first column does not come over. This is a date column. All of the other columns/rows are syncing as expected. Are there any requirements for the first column? Any ideas?

2

Hey!

That script was written by @Al_Chen_Coda . . . Al can you help out at all?

An alternative would be to sync your data in through Zapier/Make or other third party automation platforms

3

Hi @E_Browning, I would double-check that the column name you’re trying to sync from Google Sheets matches exactly to the column name in your Coda table. Sometimes there might be a leading or trailing space in the column name which would prevent the script from syncing the data.

1 Like
4

Thank you. You were correct. There was a leading space in the source file. I don’t know how that got past me because I checked that a few times, and couldn’t find it. But, it was there. its working.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.