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

> To set up recurring data imports into Coda using Google Sheets, insert the Google Sheets table into your Coda doc, enter your spreadsheet URL, and sync the data. Next, select an hourly refresh interval, open table options, and configure your preferred format and customization settings to automate the import.

Canonical: https://livedemo.ai/tutorials/how-to-set-up-recurring-data-imports-into-coda-using-google-sheets/
Apps: Google, Coda
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4e3eab56e05a00ffa103/preview?step=1

## Steps

1. Inside your Coda doc, go to the top-right corner and click 'Insert'.
2. Click the provided search bar and type 'Google Sheets'.
3. Following that, select 'Google Sheets' from the list of options under More Tables and then drag it to the main workspace for further customization.
4. 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.
5. Tap 'Sync Now' afterwards to fetch the data.
6. Subsequently, select 'Hourly' as the Refresh Interval.
7. Once done, tap 'Table Options'.
8. Choose your preferred format, then configure its corresponding customization settings based on your preference.
9. 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.