Turn Squarespace signups into enriched HubSpot contacts hourly
Every hour, pull fresh Squarespace mailing list and customer signups, research them on the web, and add enriched HubSpot contacts with a first-outreach note attached.
Squarespace Forms
HubSpotSalesMarketingLead EnrichmentData SyncEvery hour, find new Squarespace signups (mailing list subscribers, donors, and customers), research each one on the web, and create or update a corresponding HubSpot contact with a research note attached. Trigger this on an hourly cron because Squarespace Forms is not a poll provider.
Step 1: Pull new profiles from Squarespace. Call the Squarespace Forms "Retrieve All Profiles" operation, sorted by created date descending. Use a persisted lastSeenAt state value to filter to profiles that appeared since the last run. On the very first run, default lastSeenAt to one hour ago so the first execution does not backfill the entire mailing list. Update lastSeenAt to the newest profile's created timestamp at the end of the run.
Step 2: Enrich each new profile. For each profile, take the email address and any first/last name and run a focused web search to find a likely LinkedIn profile, a company website matching the email domain, or another noteworthy public signal (recent press, a personal site, a notable role). Keep the research light, one or two searches per profile. If nothing credible turns up, mark the profile as not-enriched and move on; do not fabricate.
Step 3: Upsert into HubSpot. Call the HubSpot "Batch Upsert Contacts" operation, keyed on the email property, for all new profiles in the batch. Include email, first name, last name, and any address or phone fields Squarespace returned. Upserting (not creating) means re-runs do not duplicate contacts if the same email reappears.
Step 4: Attach a research note. For each contact whose web research actually turned up something, call the HubSpot "Create Note" operation and associate the note with the upserted contact. The note should be short: a one-paragraph summary of what was found (with the LinkedIn URL or company site clearly visible), followed by a single suggested talking point for the first outreach. If a profile had only an email with nothing else findable, still upsert the contact but skip the note for that contact.
Step 5: Final output. Print a short tally: number of new Squarespace profiles seen this run, number of HubSpot contacts upserted, and number of those that got an enrichment note. Include any profiles that were skipped due to research failures so the operator can sanity-check.
Guardrails: cap the per-run profile batch at 50 to stay polite to both APIs. If Squarespace returns nothing new, exit early without calling HubSpot. Treat any HubSpot 409 (duplicate) as an expected case and continue. If web research errors out for a specific profile, still upsert the contact and skip just the note for that one.
Additional information
What does this prompt do?
- Checks Squarespace every hour for new mailing list subscribers, donors, and customer profiles since the last run.
- Researches each new signup on the web to find a likely LinkedIn profile, company website, or other public signal worth knowing about.
- Adds or updates a HubSpot contact for every new signup, keyed on email so re-runs never create duplicates.
- Writes a note on the contact summarizing what the research turned up and suggesting a talking point for the first outreach.
- Wraps up with a tally of how many new contacts were added and how many were enriched with real research.
What do I need to use this?
- A Squarespace site on a plan that includes Forms (Core, Plus, Advanced, Business, Commerce Basic, or Commerce Advanced).
- A HubSpot account where you can create and update contacts and attach notes.
- A few minutes to sign in to both when you first run the workflow.
How can I customize it?
- Change how often it runs. Hourly is the default, but a busier site might want every 15 minutes and a quieter one could go daily.
- Tighten what counts as a real enrichment. By default any web finding qualifies, but you can require a confirmed LinkedIn profile or a company website match before a note gets written.
- Tweak the talking point style. Ask for a warmer first-line, a question to open with, or a specific tie-in to your product.
Frequently asked questions
Will I end up with duplicate contacts in HubSpot if the same person signs up twice?
What happens if the workflow cannot find anything useful about a signup?
Does this cover regular contact form submissions, or only mailing list signups?
Can I use this with HubSpot Free?
How do I change the schedule or the research style?
Related templates
The moment a new contact lands in HubSpot, we check their email against known data breaches and flag the high-risk ones so your team can act fast.
The moment a new Help Scout conversation arrives, we check the customer in your CRM, flag high-value accounts, and post a priority alert to Slack before anyone touches it.
Every time a new company lands in HubSpot, we look it up on the UK register, save a due-diligence summary to the record, and alert your team to any red flags.
Each weekday morning, spot UK companies registered the day before in your target sectors, add the best fits to HubSpot, and recap them in Slack.
Every time you add a contact in HubSpot, we automatically create or update their Gladly profile so support always sees up-to-date customer details.
Every morning we scan each new company's domain, rate its external security exposure, log the findings to the CRM record, and alert your team when a vendor looks risky.
Stop letting Squarespace signups sit cold.
Connect Squarespace and HubSpot once, and Geni quietly enriches every new signup in the background every hour.