How to Connect Google Sheets to the Sparkforge Knowledge Base

By Sparkforge Support Team ·Last reviewed May 3, 2026

Sparkforge can pull data from a connected Google Sheet into the Knowledge Base. Auto-sync runs every ~15 minutes, or you can trigger a manual refresh whenever you update the sheet.

Sparkforge lets you connect a Google Sheet as a live data source for your Knowledge Base. Instead of re-uploading spreadsheet files, the Knowledge Base pulls updated values from the sheet so AI agents reference current data.

What this is good for

Use Google Sheets sync when you maintain structured data that changes regularly:

Pricing tables
Operating or support hours
Service availability
Location-specific details
Internal reference data shared across a team

Sync options

Auto sync (~15 minutes)

Sparkforge polls the connected sheet roughly every 15 minutes and pulls in new values, added or removed rows, and column changes. Use this when content changes throughout the day and AI agents should reference the latest version.

Manual refresh

Triggers an immediate pull from the sheet. Use this when you want changes live right after editing, or when you only want to push reviewed updates.

How to set it up

From your sub-account, open AI Agents and go to the Knowledge Base tab.
Open an existing Knowledge Base or create a new one.
Click Tables, then Import from Google Sheets.
If no Google account is connected, set up the Google connection using the standard Google Drive permissions Sparkforge already uses. No extra scopes are required.
Pick the connected Google account and browse to the spreadsheet.
Select the sheet you want to import.
Review the columns and assign data types, similar to a CSV upload.
Start the import and wait for processing to complete.
Leave auto-sync enabled to keep the Knowledge Base updated. Use manual refresh when you need changes live immediately.

What changes can sync

Updated cell values
New or removed rows
Added or removed columns

Frequently Asked Questions

What does Google Sheets integration do for the Knowledge Base?

It connects a live Google Sheet as a Knowledge Base source so Sparkforge can use current spreadsheet data without manual re-uploads.

How often does auto-sync update?

Roughly every 15 minutes. You can trigger a manual refresh to update on demand.

What spreadsheet changes are detected?

Cell value updates, row additions or deletions, and column changes are all picked up by sync.

What kind of data works best?

Structured tabular data such as pricing, hours, service details, or internal reference content.

Do I need extra Google permissions?

No. Sparkforge uses its standard Google Drive permissions. No additional scopes are required.