Daily Leadfeeder website visitor log to Google Sheets
Every morning at 7am, append yesterday's identified company visitors from Leadfeeder into a running Google Sheet you can pivot and chart in any BI tool.
Integrations
Leadfeeder
Google Sheets
Type
Categories
- Sales
- Operations
Build a code workflow that logs yesterday's Leadfeeder website visitors into a Google Sheet every morning so I have a running, dated history every other dashboard and BI tool can pivot against.
Trigger: cron, every day at 7:00am in my local timezone.
Step 1. Compute yesterday's date in YYYY-MM-DD.
Step 2. Call Leadfeeder's List Leads action for my account with start_date and end_date both set to yesterday. Paginate using page[number] starting at 1 with page[size]=100, incrementing page[number] until the returned data array is shorter than 100. Collect every lead across all pages into one in-memory array.
Step 3. If the array is empty, end the workflow with no writes. Do not append a blank row.
Step 4. Map each lead to a row with these columns in this order: visit_date, company_name, domain, country, industry, employee_count, lead_score, page_count, session_count, top_pages, referrer, assigned_to. Use yesterday's date for visit_date. Pull the other fields from the lead's attributes (top_pages is a comma-joined string of the lead's top page paths). If a field is missing on a lead, leave that cell blank.
Step 5. Call Google Sheets Append Values exactly once with the full batch of rows onto a designated tab in a designated spreadsheet. Use valueInputOption USER_ENTERED so dates and numbers parse correctly. One append per run, never one row at a time.
Inputs to expose at the top of the workflow: Leadfeeder account ID, target spreadsheet ID, target tab name, and an optional Leadfeeder custom_feed_id to scope the visitor list to a saved feed. The destination tab should already have a header row matching the column order above.
What it does
- Runs every morning at 7am and pulls yesterday's identified company visitors from Leadfeeder.
- Adds one row per company to a designated tab with visit date, company name, domain, country, industry, employee count, lead score, page count, session count, top pages, referrer, and assigned owner.
- Writes the full batch in a single append so you build a clean, dated history that any dashboard or BI tool can sit on top of.
- Skips the write on days with no visitors so the sheet never collects blank rows.
What you’ll need
- A Leadfeeder account on a paid plan with API access enabled.
- A Google account with edit access to the spreadsheet you want to log into.
- The spreadsheet ID and the name of the tab where the daily rows should land.
How to customize it
- Move the run time earlier or later, or switch to a weekday-only cadence.
- Narrow the visitor list to a saved Leadfeeder feed, for example ICP accounts or a specific region.
- Add or remove columns to match the shape your dashboards already expect.
Use cases
- Daily Digests
- Data Sync
