Connect Iterable to Google Sheets
Bring your Iterable data into Google Sheets with Windsor.ai, so your sheets read live campaign and engagement data.
Pick the Iterable fields you need, and Windsor.ai keeps them flowing without a CSV export in between.
Forget CSVs. Stop copy/paste. Connect in minutes. No code required.
Get your Iterable data into Google Sheets
Iterable is connected once in Windsor.ai, and these are the use cases the fields support:
Compare campaigns
Sends, opens and clicks per campaign show which campaigns people open and click.
Find the links people click
Email clicks grouped by email_click.url show which links in each campaign get clicked.
Watch unsubscribes and bounces
Unsubscribe and bounce events by campaign and email_unsubscribe.unsubSource show which sends cost you subscribers.
Using Windsor.ai to connect data from Iterable to Google Sheets
Windsor.ai moves your Iterable fields into Google Sheets on a connection you set up once, so the sheets stay on live records rather than a CSV someone exported last week.
Pick the fields you need and Windsor.ai handles the rest.
How to connect Iterable to Google Sheets with Windsor.ai
Explore a step-by-step guide to integrate your Iterable data into Google Sheets with the Windsor.ai connector.
Select your data source
Choose Iterable as your data source and enter an Iterable API key. In Iterable, go to Integrations, then API Keys, and create a new key; read-only access is enough.
Select your destination
Set Google Sheets as the destination for your data.
Select the reporting fields
Choose the Iterable fields you want to show in your spreadsheet.
Follow the setup instructions to complete the integration
Depending on the integration method you choose, set up the connection by following the prescribed steps, whether through an extension or directly via an in-app destination task.
FAQs
What Iterable data can I load into Google Sheets?
Windsor.ai gives access to 378 Iterable fields. These are the groups; the Iterable field reference lists all of them:
- Campaigns: campaigns.name, campaigns.Id, campaigns.type, campaigns.campaignState, campaigns.messageMedium, campaigns.sendSize, campaigns.startAt.
- Email events: sends, opens, clicks, bounces, complaints and unsubscribes, each with its campaign ID, template ID and time, for example email_open.campaignId, email_click.url and email_unsubscribe.unsubSource.
- Other channels: send, delivery, open and click events for SMS, push, in-app and web push.
- Templates and channels: templates.name, templates.templateId, channels.name, channels.messageMedium.
- Users: user profile fields such as users.email, users.signupDate and users.emailListIds.
- Time: Date, Week, Month, Year.
How does Windsor.ai load Iterable data into Google Sheets?
Windsor.ai sends your chosen Iterable fields straight into a sheet, either through the Google Sheets add-on or through an in-app destination task. You can set it to refresh on a schedule.
Does the Iterable connector include contact details?
Yes. Event rows carry the recipient’s email address, for example email_open.email, and open and click events also have the city, region and country. The users table has profile fields such as users.email. Pick only the fields you need when you set up a report or ask a question.
Can I combine Iterable data with other sources in my sheets?
Yes. Windsor.ai supports 350+ data sources, so Iterable data can sit next to other connected sources in the same sheets. For example, put Iterable email clicks by email_click.url and GA4 Sessions and Engaged sessions by Landing page in one table.
Do I need to code to connect Iterable to Google Sheets?
No. You connect Iterable in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.
How much does it cost to integrate Iterable with Google Sheets using Windsor.ai?
The free forever plan covers 1 data source, so connecting Iterable on its own costs nothing and needs no credit card. Combining Iterable with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.
Do you have helpful links to get started with Iterable and Google Sheets?
Yes. These are the resources to start with for the Iterable to Google Sheets integration:
Tired of manual Iterable data exports? Try Windsor.ai today to work on live data

