If you are working with data in Google Sheets and want to automatically sync it with a Coda table, this automation is for you. It will create an entry in a Coda table when a Google Sheets spreadsheet is modified.
To set it up, first, you need to create a Coda table. You can create one from scratch or select an existing table after you integrate with Coda.
Next, click the 'Pin it' button at the top of this page to save this automation. You will be redirected to install the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Google Sheets.
Now, you need to map the data from Google Sheets to Coda. To do this, hover over the Playbook card and click on 'Open Playbook in Builder.' From here, customize the last action - Coda. Choose a table and click on 'custom field mapping.' Link the data from action 1 to action 2. Save the Playbook and close the builder.
That's it! Now, every time you or your collaborators modify the Google Sheets spreadsheet, an entry will be created in the Coda table.