How to Use Google Sheets with AgentCLiQ

Overview

AgentCLiQ connects to Google Sheets through Google OAuth 2.0, enabling your AI agents to read prospect data from spreadsheets and write agent outputs back to sheets. Google Sheets serves as both an input source for outreach campaigns and an output destination for research results, classification logs, and response tracking.

---

Use Google Sheets as a Data Source for Email Sequences

Your Email Copywriter agent can pull contact data directly from a Google Sheet instead of a CRM. This is ideal for businesses that manage their prospect lists in spreadsheets.

How to use it:

1. Create a task on your Email Copywriter agent
2. On the Data Source step, select "Google Sheets" as your input source
3. Pick a spreadsheet from your Google Drive
4. Select the sheet tab containing your contacts
5. The agent reads rows as contacts with columns mapped to name, email, company, title, etc.

Column mapping: The agent auto-detects common column headers (Name, Email, Company, Title, Phone, City, State, Industry). Custom column names are matched using AI field mapping.

---

Use Google Sheets for Company Research

Your Company Research agent can pull a list of target companies from a Google Sheet. Each row represents a company to research, and the agent enriches them with web and LinkedIn intelligence.

How to use it:

1. Create a task on your Company Research agent
2. On the Data Source step, select "Google Sheets"
3. Pick the spreadsheet and tab with your company list
4. The agent reads company names (and optional domains) from the sheet
5. Each company is researched and enriched

---

Use Google Sheets for Prospect Research

Your Prospect Research agent can pull contacts from a Google Sheet and enrich each one with decision-maker intelligence, LinkedIn profiles, and role relevance scoring.

---

Write Agent Outputs to Google Sheets

After an agent completes a task, its output can be written to a Google Sheet as structured rows.

Supported output destinations:

• Email Responder outputs: classification results and response details logged as new rows
• Research results: company and prospect research appended to a tracking sheet
• Report data: structured report data written for further analysis

How to configure:

1. On the Output Destination step of any task, select "Google Sheets"
2. Pick the target spreadsheet and sheet tab
3. The agent appends rows with the output data after task completion

---

Spreadsheet Picker

AgentCLiQ provides a built-in spreadsheet picker that lists all Google Sheets in your connected Google Drive. You can browse, search, and select the exact spreadsheet and tab you need without leaving the Task Builder.

What the picker shows:

• Spreadsheet name
• Sheet tabs within each spreadsheet
• Column headers for field mapping
• Row preview for data validation

---

Write Spreadsheet Objective

The Write Spreadsheet objective type lets any agent write structured data to a Google Sheet as its primary output.

How to use it:

1. Create a task on any agent
2. Select "Write Spreadsheet" as the objective type
3. On the Spreadsheet Config step, pick the target spreadsheet and tab
4. The agent generates output and writes it as rows to the sheet on approval

---

Which Agents Use Google Sheets

Agent	What It Does with Google Sheets
Email Copywriter	Reads contact lists from sheets as the audience for email sequences
Company Research	Reads company lists from sheets, enriches them, optionally writes results back
Prospect Research	Reads contact lists from sheets, enriches decision-maker profiles
Email Classifier	Logs classification results to a tracking sheet
Email Responder	Logs interested reply details and drafted responses to a sheet
Report Generator	Writes structured report data to sheets for analysis and export
Any Agent	Can use Write Spreadsheet objective to output tabular data

---

How to Connect

1. Navigate to Settings > Integrations in your AgentCLiQ dashboard
2. Find Google Sheets in the integration list
3. Click Connect
4. You will be redirected to Google to authorize AgentCLiQ
5. Grant access to your Google Sheets and Google Drive
6. You will be redirected back to AgentCLiQ with the connection active

Requirements:

• A Google account with Google Sheets and Google Drive access
• Google Workspace or personal Google account
• Permission to authorize third-party apps

---

Permissions

• Read and write access to Google Sheets
• Read access to Google Drive for the spreadsheet picker

Existing data, formulas, and formatting in your sheets are preserved. AgentCLiQ only appends new rows and does not modify existing data. You can revoke access anytime from Settings > Integrations.

---

Limitations

• Google Sheets API rate limits apply (60 requests per minute per user). AgentCLiQ batches writes to stay within limits.
• Maximum of 10 million cells per spreadsheet (Google Sheets limit).
• The spreadsheet picker shows all sheets in your Google Drive. Use the search feature to find the right one.
• Formulas and formatting in existing sheets are preserved. AgentCLiQ only appends new rows.
• Cell-level updates (editing specific cells) are not currently supported. AgentCLiQ appends full rows.