How to Set Up Recurring Data Imports Into Coda Using Google Sheets: 1-Min Guide

How to Set Up Recurring Data Imports Into Coda Using Google Sheets

‍

It is very easy to set up recurring data imports into Coda using Google Sheets. Here’s a quick guide on how to do it:

‍

Inside your Coda doc, go to the top-right corner and click 'Insert'.
Click the provided search bar and type 'Google Sheets'.
Following that, select 'Google Sheets' from the list of options under More Tables and then drag it to the main workspace for further customization.
Enter the URL of the spreadsheet that contains the data you want to run. Make sure that the necessary permissions are granted to avoid inconveniences later on. Once done, press the 'Enter' or 'Return' key to proceed.
Tap 'Sync Now' afterwards to fetch the data.
Subsequently, select 'Hourly' as the Refresh Interval.
Once done, tap 'Table Options'.
Choose your preferred format, then configure its corresponding customization settings based on your preference.
After completing these steps, your Google Sheets data will be added to your Coda doc. Since the table is set to refresh hourly, data import is automated accordingly.