> ## Documentation Index
> Fetch the complete documentation index at: https://docs.qvista.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect Google Sheets to Qvista for Live Automation

> Monitor any Google Sheet in Qvista and automatically trigger CRM updates, API calls, team alerts, and dashboard refreshes on every new row.

Most teams already use Google Sheets to track leads, log orders, manage employee records, and compile reports. As your data grows, manually copying rows, notifying colleagues, and updating other systems becomes a time sink that Qvista is built to eliminate. Connect any Google Sheet to Qvista and turn it into a live automation trigger — the moment a new row is added, Qvista reacts instantly, routing that data wherever it needs to go. No Google Apps Script, no custom macros, no code of any kind.

## How the Google Sheets Integration Works

Once you connect your Google account in Qvista, you select a specific spreadsheet and sheet tab to monitor. Qvista watches that sheet continuously and fires a workflow trigger every time a new row appears. You define exactly what happens next — send the data to a CRM, call an external API, notify your team, or update a live dashboard. All of it runs automatically in the background.

### What Qvista Can Do When a New Row Is Added

* **Send the row data to your CRM or database** — create or update contact and deal records without manual entry
* **Call an API or webhook instantly** — forward the payload to any connected service, triggering downstream processes in real time
* **Notify your team on Slack or email** — route alerts to the right person the moment new data lands
* **Update dashboards and internal reports** — keep every visualization in sync with the source sheet automatically

## Connect Google Sheets to Qvista

<Steps>
  <Step title="Open the Integrations Panel">
    In Qvista, navigate to **Data Sources** and click **Add New Source**. Then select **Google Sheets** from the source list.
  </Step>

  <Step title="Connect Your Google Account">
    Click **Sign in with Google**. Qvista will request read access to your Google Sheets. Authorize the connection in the Google OAuth consent screen. Your credentials are encrypted and stored securely.
  </Step>

  <Step title="Select the Spreadsheet and Sheet Tab">
    Use the dropdown to browse and select the Google Sheets file you want to monitor. Then choose the specific sheet tab (for example, "Leads Q3" or "Orders"). Qvista will display a preview of the existing rows to confirm you've selected the correct data.
  </Step>

  <Step title="Map Your Column Headers">
    Qvista reads the first row of your sheet as column headers. Confirm the field mapping — for example, map column A ("Email") to the `email` field and column B ("Company") to the `company` field. Set data types for each column to ensure clean downstream processing.
  </Step>

  <Step title="Configure the Trigger">
    Choose the trigger condition. Select **New Row Added** to fire the workflow every time a new entry appears in the sheet. You can also filter triggers by column value — for example, only trigger when the "Status" column equals "New".
  </Step>

  <Step title="Define Workflow Actions">
    Add one or more actions to execute when the trigger fires. Choose from sending data to a CRM, calling a webhook, posting a Slack message, sending an email, or refreshing a Qvista dashboard. Chain multiple actions together in a single workflow.
  </Step>

  <Step title="Test the Integration">
    Click **Run Test** to simulate a trigger using the most recent row in your sheet. Qvista executes each action and shows the result so you can verify everything is wired up correctly.
  </Step>

  <Step title="Activate the Workflow">
    Click **Activate**. Qvista begins monitoring your sheet immediately. From this point on, every new row triggers your workflow automatically.
  </Step>
</Steps>

<Note>
  Qvista's Google Sheets integration requires **no Google Apps Script, no macros, and no technical setup** inside your spreadsheet. You configure everything in the Qvista interface — your sheet stays exactly as it is.
</Note>

## Business Scenarios

<Accordion title="Sales Teams — Lead Tracking">
  When your marketing team adds a new lead to a "Leads" Google Sheet, Qvista can automatically push that record into your CRM, notify the assigned sales representative, and add the contact to your marketing pipeline. You eliminate hours of manual data entry and ensure no lead falls through the cracks.
</Accordion>

<Accordion title="E-Commerce — Order Processing">
  When a new order row appears in your fulfilment Google Sheet, Qvista triggers your order processing workflow instantly. It can forward the order details to your fulfilment system, update your inventory database in real time, and send confirmation notifications — so there are no delays or missed entries between your sheet and your operations.
</Accordion>

<Accordion title="HR and Operations — Employee Onboarding">
  When an HR team member enters a new employee record into a Google Sheet, Qvista can automatically create the user account in your identity system, send a personalised onboarding email, and notify the relevant manager — connecting your HR spreadsheet directly to your internal onboarding workflow without any manual handoff.
</Accordion>

## Why Use Qvista With Google Sheets

<CardGroup cols={2}>
  <Card title="No-Code Setup" icon="wand-magic-sparkles">
    Connect your sheet and configure actions entirely through the Qvista interface — no Google Apps Script or developer involvement required.
  </Card>

  <Card title="Real-Time Automations" icon="bolt">
    Every new row triggers your workflow instantly. There is no polling delay or scheduled batch job standing between your data and your actions.
  </Card>

  <Card title="Connect Everything" icon="link">
    Integrate your sheet data with your CRM, Slack, APIs, databases, or any other system connected to Qvista — all in one workflow.
  </Card>

  <Card title="Reduce Errors" icon="circle-check">
    Eliminate manual copying and pasting between Google Sheets and other tools, removing the human error that comes with repetitive data entry.
  </Card>
</CardGroup>

<Tip>
  You can connect multiple Google Sheets as separate data sources and build cross-sheet workflows. For example, monitor a "New Orders" sheet and a "Returns" sheet independently, then surface both data streams on the same Qvista dashboard for a unified operations view.
</Tip>