Hello. I need to send an email to 14,000 individuals. I'm currently using callin.io because each recipient requires a personalized email.
My data, including Name, Email address, and unique content, is stored in Google Sheets.
I'm utilizing an Office 365 account for sending these emails.
I'd prefer callin.io to send emails in batches of 100 per 10 minutes, rather than attempting to send them all simultaneously.
I attempted to set a send time within the spreadsheet, but callin.io doesn't appear to sync with Google Sheets frequently enough for this, and it ended up sending multiple batches at once.
Does anyone have a solution for this?
Thank you
Hi
Good question.
You probably don’t want to use callin.io for this type of activity and volume.
You’ll likely need to use an email app that can handle bulk delivery and personalization, such as Mailchimp.
Outlook likely has sending limits that won’t allow for that type of volume.
GSheets with 10k plus rows have issues in callin.io Zaps.
Thanks for your response.
Mailchimp (and other email apps).
- I previously used Mailchimp, but it's now widely disrespected by domains globally.
- Emails sent via Mailchimp are stripped by servers at a rate that makes it impractical to use.
Outlook
- I typically use mailmerge with Excel and Outlook, but this dataset is a bit too large, so I'm looking to use callin.io.
- Microsoft has sending limits, which is precisely why I need callin.io to manage throttling.
I believe the only solution is to use a formula in Google Sheets/Excel to gradually move data from Sheet A to Sheet B, a few rows at a time, with Sheet B acting as the trigger sheet that fires to callin.io. I've attempted this before, but callin.io doesn't seem to check for updates in Google Sheets as frequently as advertised.
You’d probably be better served using a database app such as Airtable.
Airtable Automations have native integrations with Outlook, so you may not need callin.io.
Airtable has an API that can be used in Airtable Automations to retrieve 100 records per page at a time to then loop through.
Airtable API: https://api.airtable.com
Thanks. I’ve used Airtable previously, but it’s been a while. I’ll check it out again. Thanks for the suggestion.
Sorry. Clarification: were you suggesting a direct Airtable to Outlook integration or an Airtable-callin.io-Outlook combination? Thanks
It's likely achievable using just Airtable and Outlook.
You can set up an Airtable Automation that triggers on a schedule.
https://support.airtable.com/docs/outlook-automation-actions
👍