Hello,
We’ve set up a connection between HubSpot Data Studio and a table in our Airtable account that contains the data we need to import into HubSpot for reporting.
The connection has been in place for over a week now, but we’re running into a couple of issues. When we manually trigger a refresh, there doesn’t appear to be any change or update reflected in Data Studio. During this time, we’ve made several updates directly in the Airtable table, but they haven’t been picked up or synced to HubSpot.
Additionally, it seems that the sync behaviour is only appending new records rather than updating existing ones. Any data already stored in the HubSpot dataset isn’t being overwritten or refreshed, resulting in discrepancies in our reporting.
Has anyone experienced similar issues with Airtable integrations or Data Studio refreshes? Are there any known limitations or settings we might be missing that control how updates and overwrites are handled?
Thanks in advance for any guidance!
Hi @BGreen92,
Thanks for bringing this to the Community!
To start, it appears that this integration uses HubSpot data sync. With this in mind, we can find our guide on the syncing rules here: Connect and use HubSpot data sync
In the meantime, I’d also like to tag in some of our Top Contributors to see if they have any experience with this!
@Josh, @RubenBurdin, @SteveHTM -- Do you have any suggestions for @BGreen92 on the matter?
Thank you!
Sam, Community Manager
Hey @BGreen92 , the first thing I’d check is which integration path you’re actually using, because Airtable isn’t one of the natively supported external data sources in Data Studio. Those are Google Sheets, Excel, Snowflake, BigQuery, S3, Databricks, Azure Synapse, and Redshift (Sync data from third-party applications in Data Studio).
If you connected Airtable through HubSpot’s native Data Sync instead, that syncs into CRM objects, not directly into a Data Studio dataset, which would explain why the refresh behavior feels off.
The append only issue is almost always a match key problem. HubSpot Data Sync needs a unique identifier configured so it knows which records to update vs create new. Without tht, every cycle just adds rows. If you’re syncing contacts the match field is usually email, for companies its domain name. Worth double checking that your Airtable table has that identifier populated consistently.
If manual refresh still isnt picking up changes even with the match key sorted, it might be a polling delay. The native integrations check for updates every 5 to 15 minutes depending on load, and sometimes it takes longer than you’d expect.
One alternative we’ve seen work well for setups like this: at Stacksync we sync Airtable data into a database first and then connect that to HubSpot or reporting tools, which gives full control over refresh cadenc and upsert logic.
But fixing the match key config is probably the fastest win here.
Hope that helps!