Help Center · Integrations

Connect a Google Sheet to import leads

Updated 15 Nov 2026 · 261 views

If you keep your leads in a Google Sheet, you can link it to LeadArc and have those leads imported automatically — no exporting or re-uploading required, and no Google account sign-in needed.

Step 1: Prepare your sheet

The first row must be a header row with column names. At minimum you need:

  • name — required
  • mobile — required
These columns are optional and get filled in automatically if present:
  • email
  • company
  • source
  • priority (high, medium, or low — defaults to medium if blank or invalid)
  • notes
Column names aren't case-sensitive, and any extra columns you don't need are simply ignored.

Step 2: Share the sheet

LeadArc reads your sheet the same way a browser would export it to CSV — it does not connect to your Google account. For that to work, the sheet itself must be link-shared:

1. Open your Google Sheet and click Share (top-right)
2. Under "General access", change it from "Restricted" to "Anyone with the link"
3. Make sure the role is Viewer — LeadArc only ever reads the sheet, never writes to it
4. Click Copy link

Step 3: Connect it in LeadArc

1. Open Integrations and find the Google Sheets card
2. Paste the link you copied and click Connect & Sync

Your first sync runs immediately and shows how many leads were created.

How syncing works afterwards

  • The sheet syncs automatically about once an hour — no action needed
  • Click Sync Now at any time to pull in new rows immediately
  • Rows whose mobile number already belongs to an existing lead are skipped automatically, so it's safe to sync as often as you like — you'll never get duplicate leads
  • Rows missing a name or mobile number are skipped too
> Tip: if the Google Sheets card shows a red Error status instead of Active, it almost always means the sharing setting from Step 2 isn't quite right — double-check general access is "Anyone with the link" with the Viewer role, then click Sync Now again. The connection flips back to Active automatically as soon as the sheet becomes readable.
Related articles