How it works
Google Sheets organizes information in spreadsheets. Connect it to your Zite app to build a directory, stock tracker, or dashboard from your existing data. App visitors use the account you connect, without connecting their own Google accounts. By connecting Google Sheets, you can:- Display rows from a selected spreadsheet
- Search and filter data in your app
- Add new rows from app submissions
- Update existing rows, such as stock quantities or task statuses
- Show charts and summaries of your spreadsheet data
How to integrate Google Sheets into your app
1
Connect to Google Sheets
Ask Zite to connect Google Sheets, or click + in the chat box, select Integrations, then choose Google Sheets. Sign in to Google, approve access, and select your spreadsheet in the picker.
2
Describe your use case
Tell Zite which sheet tab and columns to use. For example, “Build an inventory app from the Stock tab. Let the team search products and update quantities.”Specify whether each action should add a new row or update an existing one.
3
Test and publish
Add two sample entries and update one of them. Check the correct tab in Google Sheets to confirm that new entries don’t overwrite existing rows.Click Publish in the upper right corner when the app works as expected.
Common use cases
With a Google Sheets connection, you can create apps like:- Inventory Trackers: Search products and update stock quantities.
- Contact Directories: Find people in an existing contact list.
- Project Trackers: Review tasks and update their status.
- Reporting Dashboards: Summarize sales, orders, or other spreadsheet data.
Important notes
- Selected spreadsheets: Signing in alone doesn’t grant access to every file. Choose the spreadsheet in the picker and use an account with permission to edit it if your app makes changes.
- Column headings: Use clear headings and tell Zite which tab to use. If you rename columns or move data, ask Zite to update the app and test again.
- Where data lives: This connection reads and writes Google Sheets. It doesn’t automatically copy rows into Zite Database; use Import data to move them there.
- Missing updates: Check the selected spreadsheet, tab, and connected account first. Tell Zite which action failed and whether it should add or update a row.
- Busy spreadsheets: Google limits how often an app can read or write data. If updates are temporarily limited, wait and ask Zite to reduce repeated checks.
Need help with this integration? Contact support@zite.com.