> ## 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.

[Connect or manage this source](https://app.vortexiq.ai/workbench/settings/sources) · [How connecting works](/integrations/connector-catalogue) · [Create a workflow](https://app.vortexiq.ai/workbench/flows/create?connector=google-sheets)

<CardGroup cols={5}>
  <Card title="12">
    performance signals
  </Card>

  <Card title="3">
    automated checks
  </Card>

  <Card title="Build your own">
    automated fixes
  </Card>

  <Card title="Ready to build yours">
    workflows
  </Card>

  <Card title="17">
    API operations
  </Card>
</CardGroup>

<Tabs>
  <Tab title="Overview">
    ### What you can achieve

    Capabilities are grouped around merchant outcomes, not API terminology.

    <CardGroup cols={2}>
      <Card title="Control risk and change">
        Keep tracking, access and change under governed control.
      </Card>

      <Card title="Run operations">
        Monitor orders, fulfilment, delivery and settlement.
      </Card>

      <Card title="Catalogue quality">
        Identify missing, inconsistent or outdated product data.
      </Card>

      <Card title="Protect revenue">
        Find failures, leaks and risks before they cost sales.
      </Card>

      <Card title="Grow revenue">
        Improve discovery, conversion, campaigns and repeat purchase.
      </Card>
    </CardGroup>

    ### From connection to verified outcome

    The controlled sequence every capability follows. Nothing changes a connected system without the approval step.

    <Steps>
      <Step title="Connect">
        Authorise the source. Scopes are shown before access is granted.
      </Step>

      <Step title="Monitor">
        Watch the signals against your own baselines, not universal defaults.
      </Step>

      <Step title="Detect">
        Run checks and gather evidence specific to your store.
      </Step>

      <Step title="Recommend">
        Explain what happened, why it matters and the proposed action.
      </Step>

      <Step title="Approve">
        You review scope, risk and reversibility before anything changes.
      </Step>

      <Step title="Execute">
        Apply through governed connector operations.
      </Step>

      <Step title="Verify">
        Confirm the intended result and keep the receipt.
      </Step>
    </Steps>

    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.
  </Tab>

  <Tab title="Monitor (12)">
    ### Monitor performance

    12 performance signals. Open an outcome to see its signals and how each one alerts. Read-only operations do not modify the connected system.

    <AccordionGroup>
      <Accordion title="Control risk and change (3 signals)">
        | Signal                      | Alert behaviour      | What it tracks                                                                                                                                          |
        | --------------------------- | -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------- |
        | **Empty Field Rate %**      | 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 fro |
        | **Error-Cell Rate %**       | 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.                |
        | **Freshness Lag (minutes)** | 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 Si  |
      </Accordion>

      <Accordion title="Run operations (3 signals)">
        | Signal                  | Alert behaviour | What it tracks                                                                                                                                         |
        | ----------------------- | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
        | **Header Schema Drift** | 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 depen |
        | **Populated Rows**      | Watch only      | Non-blank rows in the read range. Track the trend - a sudden drop signals an over-write or truncated export.                                           |
        | **Tab Count**           | Watch only      | Number of tabs (sheets\[]) in the workbook.                                                                                                            |
      </Accordion>

      <Accordion title="Protect revenue (3 signals)">
        | Signal                                        | Alert behaviour | What it tracks                                                                                                                                     |
        | --------------------------------------------- | --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- |
        | **Grid Size (rows × cols)**                   | Watch only      | gridProperties.rowCount × columnCount of the primary tab. Near the 10M-cell workbook ceiling = bloat risk.                                         |
        | **Sheet Price/Cost vs Live Storefront Drift** | 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**         | 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.  |
      </Accordion>

      <Accordion title="Catalogue quality (2 signals)">
        | Signal                    | Alert behaviour     | What it tracks                                                                                                        |
        | ------------------------- | ------------------- | --------------------------------------------------------------------------------------------------------------------- |
        | **Blank-Row Rate %**      | Alert band 2 / 10   | Empty rows inside the populated range - usually deleted-content gaps that break range-based importers.                |
        | **Hours Since Last Edit** | 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. |
      </Accordion>

      <Accordion title="Grow revenue (1 signals)">
        | Signal                                  | Alert behaviour     | What it tracks                                                                                                                                |
        | --------------------------------------- | ------------------- | --------------------------------------------------------------------------------------------------------------------------------------------- |
        | **Source Sheet Not Updated in >7 Days** | 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. |
      </Accordion>
    </AccordionGroup>
  </Tab>

  <Tab title="Audit (3)">
    ### 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. Open a check for the detail.

    <AccordionGroup>
      <Accordion title="Data-source API token invalid or access revoked">
        **Severity** critical · **Outcome** Control risk and change · **Fix status** Report only

        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 stopped updating.

        Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.

        Reference: `BYO-AUTH-001`
      </Accordion>

      <Accordion title="Source not updated in over 24h (stale data)">
        **Severity** high · **Outcome** Run operations · **Fix status** Report only

        A source that has not updated in over a day means every conclusion drawn from it describes yesterday; the staleness is invisible unless surfaced.

        Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.

        Reference: `BYO-FRESH-001`
      </Accordion>

      <Accordion title="Required-field empty rate above 15%">
        **Severity** medium · **Outcome** Catalogue quality · **Fix status** Report only

        When required fields are empty in more than 15 percent of rows, every downstream calculation inherits the gaps and quietly under-reports.

        Vortex IQ detects and explains this; resolution is manual, with evidence and recommended steps.

        Reference: `BYO-DATA-001`
      </Accordion>
    </AccordionGroup>

    #### Build your own automated fixes

    Turn any finding into an automated fix with a Vortex IQ workflow: **over 13,000 read and write operations across more than 200 connectors** are available as building blocks, with approval, verification and rollback on every change.
  </Tab>

  <Tab title="Automate">
    ### 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 **over 13,000 operations across more than 200 connectors** to automate the work in your own words.

    Changes follow your configured approval policy: the target, proposed change, affected records, risk, reversibility and verification plan are shown before execution.

    [Create a workflow](https://app.vortexiq.ai/workbench/flows/create?connector=google-sheets)

    #### 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.

    <Accordion title="Browse the operations you can build with">
      | 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.
    </Accordion>
  </Tab>
</Tabs>