Develofly Autopilot
Templates › Lead Generation & Sales › CRM row creator

CRM row creator

New leads from a sheet → your CRM (HubSpot, Pipedrive, webhook or web form).

Lead Generation & Sales

Download the app, freeOpen in Autopilot

CRM row creator: what it does, step by step, with its sample data

What it does

Sends each lead in your sheet (columns: first_name, last_name, email, company, phone, title) to your CRM: HubSpot or Pipedrive through their APIs (your private-app token / API token), any other CRM or Zapier/Make through a webhook, or the CRM's web form (web-to-lead). Each row gets crm_result (created / already in the CRM / submitted / error). Run it again on its results sheet and only new rows are sent. Change which columns go where in the step for your CRM.

How it works

  1. Decides what to do next
  2. Calls the service's API
  3. Opens the page
  4. Fills in the fields
  5. Clicks through the site
All 40 steps (as they appear in the app)
  1. If crm_result not empty
  2. Stop row: already sent to the CRM ({{crm_result}})
  3. If crm equals HubSpot
  4. POST {{hubspot_url}}
  5. If crm equals Pipedrive
  6. full_name = {{first_name}} {{last_name}}
  7. POST {{pipedrive_url}}?api_token={{crm_token:url}}
  8. If crm equals Webhook / other API
  9. POST {{webhook_url}}
  10. If crm equals Web form
  11. Open {{form_url}}
  12. name_value = {{first_name}} {{last_name}}
  13. email_value = {{email}}
  14. company_value = {{company}}
  15. phone_value = {{phone}}
  16. If name_selector not empty
  17. If name_value not empty
  18. Type “{{name_value}}” into {{name_selector}}
  19. If email_selector not empty
  20. If email_value not empty
  21. Type “{{email_value}}” into {{email_selector}}
  22. If company_selector not empty
  23. If company_value not empty
  24. Type “{{company_value}}” into {{company_selector}}
  25. If phone_selector not empty
  26. If phone_value not empty
  27. Type “{{phone_value}}” into {{phone_selector}}
  28. Click {{submit_selector}}
  29. If success_text not empty
  30. Wait for text={{success_text}} (visible)
  31. Pause 2.0s
  32. crm_result = submitted
  33. If crm_http_status not empty
  34. If crm_http_status matches ^20[01]$
  35. crm_result = created
  36. If crm_http_status equals 409
  37. crm_result = already in the CRM
  38. crm_result = error {{crm_http_status}}
  39. Stop row: The CRM said {{crm_http_status}}: {{crm_reply}}
  40. sent_at = {{now}}

Sample data included

The template comes with sample rows like these, so you can see it work before using your own list.

first_namelast_nameemailcompanyphonetitle
AdaLovelace[email protected]Analytical Engines555-0100Founder
AlanTuring[email protected]Bletchley Labs555-0101Head of Research

Get this template

1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.

Download Develofly Autopilot

2. The app comes with every template, so this one is already in your library. Click below to open it (or find it under Templates).

Open in Autopilot

What you need

  • A spreadsheet (CSV or Excel) — a sample is included
  • An API key for the service it uses

You fill in: Send to, API token (HubSpot / Pipedrive), Webhook address, Webhook headers, Web form page, Form: name field, Form: email field, Form: company field, Form: phone field, Form: submit button, Form: text shown after sending, HubSpot API address (advanced).

Make it yours

Every step is editable in the app: change the site, the columns, the schedule, or chain it with other bots. Run it once, on a schedule, or sell it as your own bot.

More Lead Generation & Sales templates

Email verifier + list cleanerDedupe a contact CSV, check email formats and drop junk rows.Event / exhibitor list builderA conference exhibitor directory → a lead sheet with websites and contacts.Local service-business finder (no API key)A niche + city → local businesses with phone, site and address (free OpenStreetMap data).Prospect enricherNames + companies → job titles, profile links and company contacts in a clean sheet.