Email Marketing Integration with Google Sheets

Google Sheets for Vero Connect makes it super simple to send any type of email message directly from a Google Sheet.

We’ve launched our latest way to access your data, via Google Sheets. Our newest Vero Connect integration gives you immediate access to the data you already have stored in Google Sheets and lets you use that data to define who your newsletter will be sent to

We have built this integration to give you more options for how to define a newsletter audience, so if you already have a spreadsheet with a list of customers or users you wish to contact, there’s no need spend time transforming or copying that data into a different format, simply connect to your Google Drive and select the sheet you want to use.

Once you’ve selected a spreadsheet to use in your newsletter all the data in your selected spreadsheet is also available to use in the content of the email using liquid syntax, exactly the same way as you would with any other audience data.

How does Google Sheets integration work?

1. Signup and connect your Google Account.
2.  Select a Google Sheet containing a list of recipient email addresses and personalization data (e.g. first names, etc.)
3. Design an email with the drag-and-drop editor, drop in raw HTML or send something more personal using the Gmail-style rich text editor.
4. Send and track your message.

Key features

• Load audiences directly from your Google Sheets, instantly.
• Design beautiful email campaigns using our visual, drag-and-drop editor.
• Personalize every email you send, at scale.
• Track opens and clicks with real-time campaign results
• Configure one or many domains to send from, giving you total control over your deliverability.

Ways to Use Google Sheets For Email Marketing 

Events. Invite people to, or follow up with attendees of, webinars, conferences and trade fairs, digital or physical events.

Surveys. Email employees, customers or, users surveys from Google Forms, Typeform or elsewhere. Follow up with Google Form respondents directly from Google Sheets.

Promotions and discounts. Send email newsletters to your customers promoting new products, discounts, and special offers.

Blog updates. Send your database new blog posts and keep them in the loop.

Product updates. Keep your users updated with product and feature announcements.

PR campaigns. Send PR campaigns to journalists, bloggers, and influencers to promote your business.

Not-for-profits. Reach out to donors and share the latest news and campaigns.

Personal greetings. Send personalized holiday greetings for Christmas, New Year, and other holidays to friends and family.

Job Applications. Apply for many jobs at once with personalized messages to HR teams and recruiters.

Say thanks. Send personalized thank-you notes to friends, family, colleagues, recruiters or anyone!

Send invitations. Invite friends, family or anyone to life events, holidays or other gatherings.

We’re excited to launch this extension to our Connect product. We hope it helps more people send great, personalized emails by building the right marketing stack for them on top of data sources like Google Sheets.

Vero Connect is a marketing automation platform built for the Modern Data Stack. Vero Connect has all the features and functionality you’d expect from marketing automation software, the core difference is where your customer data is stored. Vero Connect simply connects to your data where it already exists – that could be a cloud data warehouse like Snowflake, Amazon Redshift or a SQL database, or in a lightweight alternative like airtable or google sheets.

Thanks to everyone who voted for this feature. We’re really excited to see how you use it.

Learn more about it in our help docs.