How to Use SendGrid with Google Sheets for Email Automation

Published on October 19, 2023

Email automation is a powerful way to streamline your communication and connect with your audience more effectively. By integrating SendGrid with Google Sheets, you unlock a world of possibilities for your email campaigns.

This integration allows you to tap into the rich data stored in your Google Sheets spreadsheets and use it to create personalized and data-driven email communications. Whether you're sending out newsletters, promotions, updates, or personalized messages, the combination of SendGrid and Google Sheets provides you with the tools to engage your recipients in a more meaningful way.

Step 1: Sign Up for SendGrid

Before you can begin automating email communications, you'll need a SendGrid account.

1. Visit SendGrid: Head over to sendgrid.com in your web browser.
2. Sign Up: Look for the sign-up or registration option on the website and click on it.
3. Choose a Plan: SendGrid offers various plans to suit your email sending needs. Select the plan that best fits your requirements.
4. Complete Registration: Follow the on-screen instructions to complete the registration process, which includes providing basic information and verifying your email address.

Congratulations! You now have a SendGrid account ready to power your email communications. If you want to follow a tutorial on how to setup SendGrid, please follow this post .

Step 2: Obtain Your API Key

After signing up, navigate to your SendGrid dashboard and generate an API key. This key will be used to authenticate CodelessAPI's interactions with SendGrid. Follow this tutorial to generate your SendGrid API key. Make sure to save the generated API key for later.

Step 3: Create a New Workflow

You'll need to create a new workflow to automate your email campaign.

1. Access CodelessAPI.io: Log in to your CodelessAPI.io account.
2. Navigate to Workflow: Locate and click on the "Create new Workflow" button in the Workflow section of your CodelessAPI.io dashboard.
3. Create Your Workflow: Provide a name and description for your workflow and then click "Create". You'll be taken to the Workflow builder page where the magic happens.
   

Step 4: Connect Google Sheets to CodelessAPI

Now, let's connect your Google Sheets data to CodelessAPI. This connection allows you to fetch data directly from your spreadsheet to personalize your emails.

1. Drag Google Sheets Module: In the left sidebar of your workflow builder, expand the "Data" section, then expand the "Read" section and find the Google Sheets module and drag it onto your canvas.
2. Configure Google Sheets Module: Click on the Google Sheets module you've added to your canvas. This is where you'll set up the connection. Click on "New Google Sheets Account"
3. Authenticate Your Google Sheets Account: Follow the authentication process to connect your Google Sheets account to CodelessAPI. Afterwards, click the "Add new Google Sheets" button within Codeless API and paste the Google Sheets link that contains the data you want to send via email with SendGrid. For more detailed integration steps, refer to the guide on how to query Google Sheets.
4. Link the modules To dictate the flow of data, you need to link your modules together. Click the "Start" module and then click "Link". You should see a blue line with an arrow pointing towards your cursor. Move your cursor over to the "Google Sheets" module and click. You should now see an arrow going from the Start module to the Google Sheets module.
   

Step 5: Add the Text Replace Module

Use the "Text Replace" module if you'd like to send personalized emails or would like to use a custom template.

1. Drag Test Replace Module: In the left sidebar of your workflow builder, expand the "Operations" section and find the "Text Replace" module and drag it onto your canvas.
2. Link the modules Similar to above, link the "Google Sheets" module to the "Text Replace" module.
3. Configure the Text Replace Module: Click on the Text Replace module you've added to your canvas. Within the "Text body" field is where you can paste your html template or your personalized message.
4. Replace words for customizability Use the "Add new replace condition" option to replace words from your body text. By setting the "Replace with" to the "map" option. You can select a field from the Google Sheets data source. Make sure to click on the "Add replace condition" button after you've added yoru condition!
   
   For example, the body text "Hi [NAME]" can have the "[NAME]" replaced with data from the Google Sheets source. Each row in the data source will generate a new personalized template with all the words replaced based on the "Text Replace" modules configurations.
   

You've now added the ability to generate personalized templates! Link the "Text Replace" module to the "End" module and click run to see the output templates. Optionally add the "ChatGPT" module to before the "Text Replace" module, and then feed in both Google Sheets and the "ChatGPT" module to automate generating personalized emails!

Step 6: Adding the SendGrid Module

Now that you've set up your data source, it's time to add the SendGrid module to your workflow. The SendGrid module will enable you to send emails efficiently and effectively. Follow these steps to add it to your canvas:

1. Access Advanced Operations: In the left sidebar of the workflow builder, find the "Advanced Operations" section and expand it.
2. Select SendGrid: Among the advanced options, locate the "SendGrid" module and drag it onto your canvas.
3. Link the modules Similar to above, this time link both the "Google Sheets" module and the "Text Replace" module to the "SendGrid" module.
   

With the SendGrid module added, you're ready to configure it to connect securely to your SendGrid account.

Step 7: Configuring SendGrid module

To send emails using SendGrid, you need to provide your SendGrid API key that you generated from step 2.

1. Add SendGrid account Click on the SendGrid module on the canvas, and then select "Configure" from the options. In the configuration panel, click on "New SendGrid Account" and paste your SendGrid API key. Provide a name and description for the account. You'll now be able to configure the email configuration by clicking on your SendGrid account and then filling out the columns fields.
2. Set email values The "From email" options is set automatically based on the emails you have verified from your SendGrid account. The rest of the columns can either be set with the "manual" option or the "map" option. The manual option let's you hardcode the entry.
   
   You can now utilize the map option for your columns and map it to relevant columns coming from either the Text Replace module or the Google Sheets module. This will send an email for every row of data from your Google Sheets data source.
   
3. Link the modules You can now link the "SendGrid" module to the "End" module. This completes you workflow and ensures that it operates seamlessly.
   

Step 8: Run the Workflow

Before you finalize your email automation, it's crucial to test your workflow and ensure that emails are sent correctly. Here's how you can run the workflow for validation:

1. Use Built-in Run Feature: CodelessAPI.io offers a built-in run feature to validate your API endpoint. Click the "Run" button located at the bottom of the left sidebar to test your workflow. Please use a dummy email in SendGrid for the test.
2. Inspect Results: Review the results of your test run. Ensure that emails are being sent correctly and that the data flows as expected.
3. Copy API Link: Once you're satisfied with the results, you can either run your workflow manually or copy the API associated with your workflow to trigger it based on an event. Find your Workflow API by clicking on the "Start" module and selecting the "Configuration" option. Copy the provided API link.

Congratulations! You've reached the final step and are now ready to harness the power of automated, personalized email communication.

Conclusion

By integrating SendGrid with Google Sheets, you can streamline your email automation and deliver personalized emails efficiently.

This combination allows you to harness the power of data-driven email campaigns, ensuring that your audience receives tailored and relevant messages. Whether you're sending out newsletters, promotions, or updates, this integration empowers you to connect with your recipients in a more personalized way.

If you encounter any challenges along the way or have questions, don't hesitate to reach out to us at hello@codelessapi.io.