Google Sheets integration

Google Sheets is where a large share of real outreach actually runs: a shared spreadsheet, a Status column, a filter view per teammate, and conditional formatting that shows who has been called. What breaks that setup is feeding it — every new lead list means a CSV download, an import, a dedupe pass against last month's tab, and a VLOOKUP merge that only matches on the first column and silently misses the rest. The LeadMarina Google Sheets export removes that cycle: searches deliver fully verified local-business leads directly into a spreadsheet, and every later export updates the same rows in place.

Choosing a destination

Any search can be exported to Google Sheets. At export time you pick one of two destinations:

• A new spreadsheet, which LeadMarina creates.
• A spreadsheet LeadMarina created in an earlier export.

You can't target an arbitrary spreadsheet you built yourself — updates rely on a hidden identifier column that LeadMarina manages (details below). If you need lead data inside another workbook, pull it across with IMPORTRANGE or QUERY and keep the LeadMarina spreadsheet as the source of truth.

What lands in each row

All LeadMarina columns export. Each row is one business — one delivered, fully verified lead against your balance — and includes:

• Up to 3 emails, each SMTP-checked and labeled safe, risky, or invalid.
• Up to 3 phone numbers, each with line type (mobile, landline, VoIP, or toll-free) and carrier.
• Owner name, where identifiable.
• Social profiles: Facebook, Instagram, LinkedIn, X, YouTube, TikTok, Yelp.
• Ratings and reviews, plus the full business profile from Google business listings data.

One column is deliberately hidden: it holds the stable Google business identifier LeadMarina uses to match rows on later exports. Leave it in place. Separately, if you hide columns you don't work with, they stay hidden on later exports — the values underneath still update.

Working the list in Sheets

Everything you normally do in a lead spreadsheet works, because LeadMarina only ever writes its own columns:

• Add your own tracking columns. A Status dropdown (Insert → Dropdown, chip format), a Last touched date, a Notes column. These are user-created data — exports never modify them.
• Flag deliverability with conditional formatting. Add a custom-formula rule on the Email 1 Status column — for example =$E2="safe" if Email 1 Status sits in column E; the exact letter depends on where that column lands in your sheet — to turn workable rows green, and a second rule to catch invalid. Rules evaluate in order — the first true rule wins.
• Cut call lists with FILTER or QUERY. On a second tab: =FILTER(Leads!A2:Z, Leads!E2:E="safe") for a quick slice, or =QUERY(Leads!A:Z, "select * where E = 'safe' order by J desc") for SQL-style sorting and grouping. Both examples assume Email 1 Status is column E — swap in the actual letter from your sheet.
• Give each teammate a filter view. Filter views are saved and personal — one rep filters to mobile lines while another sorts by rating, without changing what anyone else sees.
• Protect the data columns. Use Data → Protect sheets and ranges with "Show a warning when editing this range" on LeadMarina's columns, so nobody hand-edits a value the next export will refresh anyway.
• Share deliberately. Editor for people working the list; Commenter or Viewer for everyone else, with download, print, and copy disabled if needed.

Update-in-place semantics

Every export matches rows by the stable Google business identifier in the hidden column — not by row position or business name:

• No duplicates. A business already in the sheet updates in its existing row; re-running a search never appends a second copy.
• Sorting is safe. Matching is by identifier, so you can sort and reorganize rows freely.
• User data is never touched. Rows you add, columns you add, notes, and formatting are left alone on every export.

When a value changes between exports — an email flips from safe to invalid, a phone number changes — the cell updates. Sheets version history is your audit trail: right-click a cell → Show edit history to see prior values, or restore an earlier version of the file.

Scheduling and automation

Any search can repeat once, daily, weekly, monthly, or yearly with Google Sheets as the destination — the spreadsheet becomes a self-refreshing prospect list. To hear about changes without opening the file, set a Sheets notification rule (Tools → Notification settings): email right away, or a daily digest.

For custom automation, the REST API is available on every plan, including free (bearer API keys), and the MCP server at https://leadmarina.com/api/mcp exposes search_leads, export_leads, and five other tools — an agent or script can run a search and push results into Sheets without touching the dashboard.

Troubleshooting

• "Can I export into my existing spreadsheet?" Exports go to a new spreadsheet or one LeadMarina created earlier — updates rely on the hidden identifier column LeadMarina manages. Use IMPORTRANGE from your own workbook instead.
• Hidden columns. Columns you hide arrive hidden on later exports but still update. If a value looks stale, unhide the column and check.
• Don't delete the hidden identifier column. Row matching depends on it.
• Very large lists. Google Sheets caps a spreadsheet at 10 million cells (18,278 columns). At higher plan volumes — up to 240,000 leads per month — keep separate searches in separate spreadsheets rather than one master file.
• Billing. One meter: 1 lead = 1 delivered, fully verified business. The free plan includes 100 leads; paid plans include 15,000, 65,000, or 240,000 leads per month.