> ## Documentation Index > Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt > Use this file to discover all available pages before exploring further. # Google Sheets on Vortex IQ > Monitor Google Sheets publishing, engagement and freshness, and catch decay before organic reach erodes. Monitor Google Sheets publishing, engagement and freshness, and catch decay before organic reach erodes. No changes are made without the configured approval policy. Read-only operations do not modify the connected system; schedules, access scopes, API usage and data handling remain governed by Vortex IQ controls. [Connect or manage this source](https://app.vortexiq.ai/workbench/settings/sources) · [How connecting works](/integrations/connector-catalogue) | **12** | **3** | **Build your own** | **Ready to build yours** | **17** | | ------------------- | ---------------- | ------------------ | ------------------------ | -------------- | | performance signals | automated checks | automated fixes | workflows | API operations | ## Monitor performance 12 performance signals. Signals with an alert band can raise Nerve Centre alerts; every signal supports a merchant-configured watcher. | Signal | Outcome | Alert behaviour | What it tracks | | --------------------------------------------- | ----------------------- | -------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | **Error-Cell Rate %** | Control risk and change | Alert band 0 / 1 | Share of read rows containing #REF!/#N/A/#DIV/0!/#VALUE! when rendered FORMATTED\_VALUE. These poison any importer that trusts the cell. | | **Header Schema Drift** | Run operations | Merchant rule | Diff of the header row (row 1 of the range) against the last-known-good header signature. Catches renamed/reordered/deleted columns the importer depends on. Requires hist | | **Hours Since Last Edit** | Catalogue quality | Alert band 24 / 168 | Drive files.get modifiedTime → now. A feed sheet that hasn't moved in a week is almost always a stalled upstream job. | | **Sheet Price/Cost vs Live Storefront Drift** | Protect revenue | Merchant rule | The pricing/cost master sheet and the live store disagree for the same SKU - either the store is selling at the wrong price or the sheet is stale. | | **Sheet SKUs Missing From Catalogue** | Protect revenue | Merchant rule | SKUs in the source-of-truth sheet that don't exist in the live catalogue - orphaned overrides, typos, or a feed that ran ahead of the store sync. | | **Source Sheet Not Updated in >7 Days** | Grow revenue | Alert band 24 / 168 | Fires when the spreadsheet has not been edited within the expected refresh cadence - the single highest-signal failure mode for a feed sheet. | | **Blank-Row Rate %** | Catalogue quality | Alert band 2 / 10 | Empty rows inside the populated range - usually deleted-content gaps that break range-based importers. | | **Empty Field Rate %** | Control risk and change | Alert band 2 / 15 | Share of cells left blank across the read range's data rows, measured against the header row's column count (values.get FORMATTED\_VALUE). Distinct from Blank-Row Rate, wh | | **Freshness Lag (minutes)** | Control risk and change | Alert band 60 / 1440 | Drive files.get modifiedTime -> now, in minutes (the byo\_data\_source archetype's freshness\_lag band is minutes, not hours - same source as Hours Since Last Edit, differen | | **Grid Size (rows × cols)** | Protect revenue | Watch only | gridProperties.rowCount × columnCount of the primary tab. Near the 10M-cell workbook ceiling = bloat risk. | | **Populated Rows** | Run operations | Watch only | Non-blank rows in the read range. Track the trend - a sudden drop signals an over-write or truncated export. | | **Tab Count** | Run operations | Watch only | Number of tabs (sheets\[]) in the workbook. | ## Audit risks and opportunities A fix status appears only where the action, inputs, approval, verification and recovery controls are mapped. Candidate remediations are never executable. | Check | Severity | Outcome | Why it matters | Fix status | | --------------------------------------------------- | -------- | ----------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- | | **Data-source API token invalid or access revoked** | critical | Control risk and change | Once this token fails, VortexIQ stops pulling data from this source entirely, and every card and finding built on it goes stale from that moment, silently, until someone notices the numbers | Report only | | **Source not updated in over 24h (stale data)** | high | Run operations | A source that has not updated in over a day means every conclusion drawn from it describes yesterday; the staleness is invisible unless surfaced. | Report only | | **Required-field empty rate above 15%** | medium | Catalogue quality | When required fields are empty in more than 15 percent of rows, every downstream calculation inherits the gaps and quietly under-reports. | Report only | ### Build your own automated fixes 3 checks report findings on Google Sheets today. Turn any finding into an automated fix with a Vortex IQ workflow: **13,885 read and write operations across 229 connectors** are available as building blocks, with approval, verification and rollback on every change. ## Automate approved work Vortex IQ is integrated with **4 read** and **13 write** operations across spreadsheets.values, spreadsheets, spreadsheets.developermetadatas, spreadsheets.sheets on Google Sheets. Combine them with anything from the **13,885 operations across 229 connectors** to automate the work in your own words. Changes follow the merchant's configured approval policy: the target, proposed change, affected records, risk, reversibility and verification plan are shown before execution. Read-only operations do not modify the connected system. [Create a workflow](https://app.vortexiq.ai/workbench/flows/create?connector=google-sheets) | Resource | Read operations | Write operations | | ------------------------------- | --------------- | ---------------- | | spreadsheets.values | 2 | 8 | | spreadsheets | 1 | 3 | | spreadsheets.developermetadatas | 1 | 1 | | spreadsheets.sheets | 0 | 1 | Signed-in users see the full catalogue in the workflow builder, filtered to the sources they have connected. ### Ready to build your first Google Sheets workflow Pick a trigger, add the operations above as steps, and every step that changes data pauses for your approval. Monitoring and audits are live now and can start any workflow you build. *** *Generated from the connector capability graph. Counts reflect the servable registry after alias normalisation and de-duplication, and refresh automatically when the registry changes.*