Revenue Scout + Google Sheets

Put social leads in the sheet your team already uses.

Your Agentic Coworker finds and vets social media leads. Bring the original source, stated need and selected sales context into Google Sheets. Scout handles the handoff, while your team keeps its own working notes beside the lead.

Get 2,000 free credits worth $30.

Every feature and all seven platforms. No credit card required.

You choose the columns and activate the rule. Setup writes no row.

CHOOSE THE COLUMNS. KEEP THE CONTEXT.

Scout brings the lead.
Your team takes it from here.

Inspect a fictional sheet with header row 1. Scout maps the source and selected values into named columns. Your team keeps its own notes in columns outside that mapping.

ProspectingIllustrative file · Leads tab · Header row 1
YOUR WORKSPACE
AOriginal sourceScout-mapped
source_url

Original public post URL

BConversationScout-mapped
excerpt

Help matching Shopify payouts to orders

CStageScout-mapped
sales_stage

conversation

DFollow-upScout-mapped
follow_up_at

Empty when no follow-up time is saved

EScout keyRequired tracking
record_key

One stable key for this Scout record

FDelivery IDRequired tracking
operation_id

The latest handoff’s operation ID

GTeam noteTeam-owned
Not mapped

Alex: discuss at the weekly review

Column names are examples. Review your actual file, tab, header row and mapped values before activation.

01 / NEW ROW

Right below your header.

A new tracked row is inserted immediately below the selected header row. With header row 1, that new row is row 2, rather than the bottom of the sheet.

Scout writes the mapped values as text and records the row’s tracking. The example’s team-note column has no Scout value in the new row.

New row: selected values and two tracking columns.
02 / TRACKED UPDATE

The same row. Current context.

Scout checks the row’s saved tracking and matching record key before updating it. It updates selected columns and the latest delivery ID.

Existing cells outside the mapping are skipped. The team’s note in column G stays outside Scout’s update. Mapped manual values or formulas can be replaced.

Existing row: keep team notes and calculations unmapped.
03 / MISSING VALUE

An empty value is still a write.

If no follow-up time is saved, this example sends an empty value to mapped column D. On an existing row, that can clear the cell.

Review missing mapped values before activation. Editing the spreadsheet does not automatically update Scout’s pipeline or add a follow-up in Scout.

Mapped blank: can empty its cell. Unmapped cell: skipped.
Your actual workspace

How do I choose the right spreadsheet?

In Connections, name the Google Sheets connection and select its brands. Connect Google, choose your spreadsheet with Google Picker, then select its grid tab and header row. Scout checks that the file is authorized for the app and editable by the connected account.

Use the file and tab your team intends to work in. The header-row choice uses the row numbers you see in Sheets. Inspect the current column headings before mapping them. Verification saves the reviewed destination without writing a row.

Evidence in the columns you choose

What can Scout bring into the sheet?

Map available source evidence and sales context into named columns: the original post URL, conversation excerpt, title, sales stage, follow-up time and supported profile details. Choose only the columns you want Scout to write.

Give the Scout record key and latest delivery ID separate named columns, each mapped exactly once. Each destination column is used once. Those two tracking columns help Scout identify the row and the particular handoff. They are not a prospect’s email address or proof of identity.

Values are written as text without automatic number, date or formula parsing. Source evidence may be incomplete. Scout does not invent missing identity details, and a public post does not establish permission to contact someone.

Your team’s space stays useful

How do I keep team notes beside the lead?

Leave team-note and calculation columns outside Scout’s mapping. Updates to an existing tracked row skip unmapped cells. A mapped cell can replace a manually entered value or formula, and a missing mapped value can clear that cell.

Keep the two tracking columns intact. Scout checks the saved row tracking and matching record key before updating a row. Duplicate keys, missing anchors or conflicting tracking stop for review rather than silently redirecting the update.

From connection to reviewed work

When does a row get created or updated?

After verifying the connection, choose the automation event and Sheets destination. Preview the selected records and mapped values, then activate the reviewed rule. Connecting alone starts no row handoff.

A new tracked row is inserted immediately below the selected header row. An update uses the existing row’s verified tracking. Changes you make in Google Sheets do not automatically change Scout’s pipeline. Continue stages, owners and next steps in Scout when they need to affect Scout’s work.

A row accepted by Google Sheets is a workspace handoff. It is not an email sent, a social reply posted or a completed sale. Gmail and manually posted social replies keep their own review and approval boundaries.

A short path into your existing workflow

Pick the sheet. Map the columns. Activate the work.

Start with the workspace your team knows. Keep account access, a verified mapping and an active automation as clear, separate decisions.

01 / Choose

Confirm the file, tab and header row

Choose the Google-authorized editable spreadsheet. Inspect the actual tab and column headings. Setup reads the destination without creating a row.

02 / Map

Select evidence and tracking columns

Map the values your team needs and the two separate tracking columns. Keep notes and calculations outside the mapping. Review blank values before verifying.

03 / Activate

Preview the row before the rule runs

Review the event, records and destination values, then activate the rule. Inspect its saved outcome and refresh the mapping when the destination changes.

FOLLOW THE ROW, NOT A GUESS

A checkable handoff.
A clear next step.

The saved operation, selected destination and row tracking keep recovery tied to the original work. Read the outcome before taking another action.

Open your connections
Row accepted

Google Sheets accepted the recorded write. Read the destination row and continue the team’s workflow. A saved row is not a prospect contacted or a sale made.

Headers or tracking changed

Inspect the selected tab and headers again, then review the mapping. Duplicate keys, missing row tracking or conflicting anchors need review. Scout does not silently choose a different row.

Google access needs attention

Check the saved connection and renew Google sign-in when needed. Confirm the intended file is still authorized for Scout and editable by the connected account before continuing.

Delivery uncertain

Inspect the same saved operation and spreadsheet row before another handoff. A timeout is not proof that nothing was written. Preserve the Scout key and delivery identity during recovery.

Questions?

Before you start.

Answers to help you decide and take the next step.

Does connecting Google Sheets immediately create a row?

No. Connection setup verifies the selected file, tab, headers and mapping. Configure and preview the relevant automation, then activate the reviewed rule to authorize row handoffs. Setup alone writes no row.

Which Google files can I choose?

Choose a spreadsheet through Google Picker using the connected account. Scout verifies that the file is authorized for the app, is not trashed and is editable. Select a grid tab in that file, rather than assuming a document link alone grants access.

Can my column headers start below row 1?

Yes. Choose the actual header row during setup, using the row number you see in Google Sheets. Scout inspects that row’s headings and binds the mapping to the selected file and tab. Mapped columns need nonempty names.

Why do I need a Scout key and delivery ID column?

The Scout record key identifies the source record. The separate latest delivery ID identifies the handoff. Map each once to a different named column and preserve them alongside the row tracking. Do not substitute a prospect name or email for those values.

Where does Scout place a new row?

Immediately below your selected header row. For a header on row 1, the new row is inserted at row 2. This is not an append-to-the-bottom workflow. Scout writes the mapped values and records tracking for that row.

Will an update overwrite my team’s notes or formulas?

Existing cells outside the mapping are skipped. Mapped cells can replace a manually entered value or formula on an authorized update. Keep team notes and calculations in unmapped columns, and inspect the actual mapping before activation.

What happens when a mapped value is missing?

Scout sends an empty value for that mapped cell. On an existing row, this can clear the cell. An unmapped column is skipped instead. Review missing follow-up times, profile details and other mapped values before activating the work.

Do spreadsheet edits update Scout’s pipeline?

No automatic reverse sync is implied. This connector brings selected Scout values into Google Sheets. Update stages, owners and follow-up work in Scout when those changes need to affect Scout’s pipeline or automations.

What if I rename headers or copy the tracking columns?

Inspect the selected file, tab and headers again, then review and verify the mapping. Duplicate keys, missing row tracking or conflicting anchors need investigation. Scout does not silently select another row or create a replacement to bypass a tracking conflict.

What should I do if delivery is uncertain?

Inspect the same saved operation and destination row before another handoff. A timeout or missing acknowledgement is not proof that nothing was written. Keep the original Scout key and delivery identity while checking the outcome.

Can I pause a rule or disconnect Google Sheets?

Manage the rule in Automations and the connection in Connections. Pausing or disconnecting stops new authorized work through that rule or connection. It cannot recall a row Google Sheets already accepted. Inspect in-flight or uncertain work separately.

Do I need a spreadsheet or a different Scout plan to start?

No. Start with social media lead discovery and saved evidence, then add Sheets when it fits your team. Every Scout plan includes connectors. Choose credit capacity for your prospecting work and keep Google’s own account, access and service terms in view.

Give Scout the prospecting

Bring useful conversations into your team’s working day.

Start with social media lead discovery. Connect your sheet when you are ready to review its columns and activate a workspace handoff.

Get 2,000 free credits worth $30.
Start freeNo credit card required