全部範本

銷售

Research Sales Accounts in Google Sheets

Research companies on the web and update their matching spreadsheet rows.

Research Sales Accounts in Google Sheets 在 Open Flow 中的工作流程截圖Research Sales Accounts in Google Sheets 在 Open Flow 中的工作流程截圖

Research companies on the web and update their matching spreadsheet rows.

Setup and use

Import Sales account research and Sales research tools, publish the research tool and refresh the agent tools. Configure Google Sheets, Firecrawl, a tool-capable model and SERPAPI_API_KEY. Set the spreadsheet and worksheet and create columns input, enrichment_status, domain, linkedinUrl, market, cheapest_plan, has_entreprise_plan, has_API, has_free_trial, integrations and last_case_study_link. Enable persistent State and do not reorder rows or overlap runs while processing. Run manually or use the built-in two-hour UTC schedule. Inspect a pending row before retrying an uncertain write. Research results require human review.

In n8n

In n8n configure the same sheet, model, SerpAPI, website tool and a Data Table with item_key and status columns.

Inspiration & credits

Adapted from AI web researcher for sales in enescingoz/awesome-n8n-templates.

Source collection notice: © 2024–2026 Enes Cingoz, CC BY 4.0. The source export does not identify a separate template author or license. See repository licensing for the scope of OOMOL contributions and third-party material.

Original workflow by lempire. Changes: use Firecrawl for page text, repair structured outputs and row association, and add update checkpoints.

Collection license notice:

Creative Commons Attribution 4.0 International License

Copyright (c) 2024-2026 Enes Cingoz

You are free to:

  Share - copy and redistribute the material in any medium or format
  Adapt - remix, transform, and build upon the material for any purpose,
  even commercially.

Under the following terms:

  Attribution - You must give appropriate credit, provide a link to the
  license, and indicate if changes were made. You may do so in any
  reasonable manner, but not in any way that suggests the licensor
  endorses you or your use.

  No additional restrictions - You may not apply legal terms or
  technological measures that legally restrict others from doing
  anything the license permits.

Notices:

  You do not have to comply with the license for elements of the
  material in the public domain or where your use is permitted by an
  applicable exception or limitation.

  No warranties are given. The license may not give you all of the
  permissions necessary for your intended use. For example, other rights
  such as publicity, privacy, or moral rights may limit how you use the
  material.

For the full license text, see:
https://creativecommons.org/licenses/by/4.0/legalcode