)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot workflows can’t trigger from anonymous form submissions because they require contact associations to function. When forms don’t collect email addresses or other identifying information, no contact record gets created, leaving these valuable submissions stuck in HubSpot.
Here’s how to automatically capture all anonymous form data in Google Sheets, even when workflows won’t work.
Pull anonymous form data directly using Coefficient
Coefficient connects directly to HubSpot’s Forms API, completely bypassing the workflow limitation. Instead of relying on contact associations, it pulls form submission data at the source level, capturing every response regardless of whether a contact record was created.
How to make it work
Step 1. Connect to HubSpot Forms in Coefficient.
Open Coefficient’s sidebar in Google Sheets and select HubSpot as your data source. Choose “Form Submissions” from the available options. This connects directly to your form submission database, not your contact records.
Step 2. Select your specific form and configure the import.
Choose the form you want to track from the dropdown menu. Select all relevant fields including custom properties, submission timestamps, and any hidden fields. Coefficient will import all submissions from this form, including anonymous ones.
Step 3. Set up automatic refresh scheduling.
Configure your import to refresh hourly or daily to capture new anonymous submissions automatically. This creates a continuous data flow without requiring any workflow triggers or contact properties.
Step 4. Filter for anonymous submissions only.
Use Coefficient’s filtering capabilities to isolate submissions where contact email is blank or null. This ensures you’re only seeing the anonymous feedback data you need for analysis.
Step 5. Enable automatic formula processing.
Set up Formula Auto Fill Down for any calculated columns like submission categorization or timestamp formatting. These formulas will automatically apply to new anonymous submissions as they’re imported.
Start capturing anonymous form data automatically
This approach gives you complete visibility into anonymous form submissions without the limitations of contact-based workflows. Try Coefficient to start syncing all your HubSpot form data automatically.
