{"product_id":"n8n-workflow-save-new-larvabot-leads-to-google-sheets","title":"n8n Workflow: Save New Larvabot Leads to Google Sheets","description":"\u003ch3\u003eAutomatically capture new Larvabot leads into Google Sheets (every 15 minutes)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls newly \u003cstrong\u003efound\u003c\/strong\u003e leads from the \u003cstrong\u003eLarvabot API\u003c\/strong\u003e, removes duplicates across runs, and appends each new lead as a row in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—so your lead pipeline stays up to date without manual work.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e the workflow triggers \u003cem\u003eevery 15 minutes\u003c\/em\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches new leads from Larvabot:\u003c\/strong\u003e it calls the \u003cstrong\u003eLarvabot API\u003c\/strong\u003e to retrieve up to \u003cstrong\u003e100\u003c\/strong\u003e leads with the event set to \u003cstrong\u003e“found”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates leads across executions:\u003c\/strong\u003e before writing data, it removes any leads whose IDs have already been processed in previous workflow runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets:\u003c\/strong\u003e it writes only the remaining new leads to your selected Google Sheets worksheet, mapping JSON fields to your sheet’s column headers.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS lead tracking:\u003c\/strong\u003e keep a Google Sheet continuously updated with fresh Larvabot leads for sales and outreach workflows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOps \/ automation engineering:\u003c\/strong\u003e reliably consolidate lead data from an external API into a spreadsheet your team already uses.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFast pipeline visibility:\u003c\/strong\u003e reduce delays between lead discovery and internal review by syncing every 15 minutes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e (runs every 15 minutes)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e to the \u003cstrong\u003eLarvabot API\u003c\/strong\u003e (up to 100 leads; event = “found”)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRemove Duplicates\u003c\/strong\u003e based on processed lead IDs\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to append rows and \u003cstrong\u003emap JSON fields\u003c\/strong\u003e to your header row\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuth:\u003c\/strong\u003e use an HTTP Header Auth credential with \u003ccode\u003eAuthorization: Bearer \u0026lt;your_key\u0026gt;\u003c\/code\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup in brief\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd your \u003cstrong\u003eLarvabot API key\u003c\/strong\u003e using \u003ccode\u003eAuthorization: Bearer \u0026lt;your_key\u0026gt;\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e, then select the target spreadsheet and worksheet.\u003c\/li\u003e\n  \u003cli\u003eEnsure your sheet includes a \u003cstrong\u003eheader row\u003c\/strong\u003e matching the lead fields you want to store for correct auto-mapping.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46203573862579,"sku":"N8N-20760","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/SRprbBLn3dwGXbk9d2Wn3_NNvTrQQL.png?v=1791709455","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-save-new-larvabot-leads-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}