Connecting Google Sheets and other spreadsheets
Sync data between your app and a Google Sheet (or Airtable, or Excel Online). Two-way or one-way.
Want your app to read from (and write to) a spreadsheet you already use? OverSkill connects to all the common ones.
Supported sources
- Google Sheets
- Airtable
- Excel Online (Microsoft 365)
- Notion databases
Each works similarly: you give the AI a link, it walks you through connecting your account, and the sync starts.
Setting it up
Connect this Google Sheet as my Orders data: [paste the share link]
The AI:
- Asks you to authorize OverSkill to read the sheet (one click)
- Looks at the columns and proposes a mapping
- Asks if you want one-way (sheet → app) or two-way (changes flow both ways)
- Confirms and starts syncing
One-way vs two-way sync
One-way (most common):
- The spreadsheet is the source of truth
- Changes in the sheet appear in your app within seconds
- Edits to the data in your app DON'T flow back to the sheet
- Good for: read-only dashboards, public catalogs, scheduled reports
Two-way:
- Edits in the app update the spreadsheet
- Edits in the spreadsheet update the app
- Conflicts (both edited at once) are resolved by recency
- Good for: collaborative apps where some team members prefer the spreadsheet
What happens if the sheet changes structure
If you rename a column or add a new one, the AI usually notices on the next sync and asks what to do:
I see the column 'Order Date' was renamed to 'Created'. Should I update the mapping?
Answer in chat. The sync resumes.
Frequency
By default, syncs happen every 5 minutes. You can adjust:
Sync this sheet every hour.
Sync this sheet only when I manually refresh.
Disconnecting
Disconnect the Google Sheet sync.
Your app keeps the data it has. Future changes in the sheet won't flow in.
What to read next
- Importing data — one-time import if you don't need ongoing sync
- Exporting your data — go the other direction