Daily Leadfeeder website visitor log to Google Sheets

PromptCreate

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.

Additional information

What does this prompt do?

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 do I need to use this?

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 can I 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.

Frequently asked questions

Will this work on the free Leadfeeder plan?

No. Leadfeeder gates API access to paid plans, so you need at least a paid tier for the daily pull to return data.

What happens on days with no website visitors?

Nothing is written. The workflow skips the append on empty days so your sheet does not collect blank rows.

Can I point this at a different spreadsheet later?

Yes. Update the spreadsheet ID and tab name in the workflow inputs and the next run will start writing to the new destination.

Will it create duplicate rows if I run it twice in one day?

It always appends the visitors Leadfeeder reports for yesterday's date range, so a second run on the same day would re-append the same companies. Run it once per morning, or filter on the visit date column downstream.

Can I connect this sheet to Looker, Tableau, or Power BI?

Yes. That is the point of the dated, one row per company format. Any BI tool that connects to Google Sheets can sit on top of this log directly.

Related templates

Auto-refresh a Google Sheet from Databricks every night

Every night we run your saved Databricks query and refresh a Google Sheet with the results, so your team reads the latest numbers without a login.

5d ago

Deterministic Code

Prompt

Log daily football results and league standings to Sheets

Every morning, automatically record yesterday's match results and each league's latest table into a spreadsheet you can chart or pivot.

5d ago

Deterministic Code

Prompt

Daily IP reputation screening with Slack threat alerts

Every morning we check your list of IP addresses for abusive activity, update your spreadsheet, and alert your team only about the risky ones.

5d ago

Agentic Task

Prompt

Log every new Azure DevOps work item to Google Sheets

Automatically add every new Azure DevOps work item to a Google Sheets tracker so your team can filter, sort, and report without opening Azure DevOps.

5d ago

Deterministic Code

Prompt

Daily data breach monitoring for key email accounts

Check key email accounts against known data breaches every weekday, log every exposure to a spreadsheet, and get a Slack alert when a new breach shows up.

5d ago

Deterministic Code

Prompt

Morning team travel briefing with live flight alerts

Every weekday morning, your team gets one Slack briefing on who's flying today, their live flight status, and any delays or cancellations to act on.

5d ago

Agentic Task

Prompt

Stop losing yesterday's website visitors.

Connect Leadfeeder and Google Sheets once, and Geni logs every identified visitor into a clean, dated history your dashboards can sit on top of.

Explore more prompts Create