I have a table that was originally in Google Sheets, but I am trying to use Coda for it now. Unfortunately, the original Google Sheet still needs to be updated with changes I make in the Coda version. Is there an existing method to create this syncing?

There is no native option for this. You can create a connection using services like zapier/integromat/parabola or with Google apps script

Hi @cylo , thanks for your question. As @Asaf_Dafna mentioned there is no native way to sync data from your Coda docs to Google Sheets. The easiest way to do this is to use something like Zapier . If you are comfortable with a little bit of scripting in Google Apps Script, you can use the Google Sheet…

@Al_Chen_Coda , Might you (or anyone else) have a simple example of such a Coda API/Sheets API combination? I only need to sync one Coda table to one Google sheet (totally okay if everything gets written over every time the trigger runs) Have gone through your blog post and related video on YouTub…

Have you seen this Script example: https://blog.coda.io/how-to-sync-data-between-coda-docs-and-google-sheets-using-google-apps-script-128307ec2ad9

I’m working on a tutorial (blog post + YouTube video) on this very subject, will publish here in the community in the coming weeks when it’s ready :+1:

@Al_Chen_Coda What wonderful news — very much looking forward to that tutorial. Thank you for the update. We’ve also recently updated to the Team plan, and are loving it!

@Al_Chen_Coda Hi Al, any updates on the GAS script from Sheets to Coda? We currently have scripts setup from various sources which place data inside a Google Sheet. I want to make sure I have the end code right so that we can place that array directly into Coda.

Still working on it! Will post an update here once I have something I can share.

Thanks @Al_Chen_Coda I will get on this later tonight, really appreciate your help with this :+1:

Can I sync data from a Coda table to a Google spreadsheet?

Al_Chen_Coda May 4, 2020, 3:16pm 10

Hi @cylo @Michael_Warren @Shaun_Singh, just posted two Google Apps Scripts you can use for syncing Coda to Sheets or Sheets to Coda in the community, hope these help!

Topic		Replies	Views
How to sync data from Coda to Google Sheets and Google Sheets to Coda using Google Apps Script	76	11335	October 28, 2021
How do you regularly import a Google Sheet into a Coda Table? Making Packs	6	3554	May 9, 2020
Setup question regarding multiple Google Sheets to Coda tables	9	1087	July 29, 2021
Syncing Data from Excel to Coda Table	7	951	August 3, 2022
Google Sheet to coda ( Column Sync issue)	1	492	April 3, 2023

Can I sync data from a Coda table to a Google spreadsheet?

Related topics