Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Automatically Generate HTML Emails with AI Using Google Sheets

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin using Pabbly Connect, you need to visit pabbly.com/n in your browser. This will direct you to the Pabbly Connect homepage where you can either sign in or sign up for free.

If you’re a new user, click on the “Sign Up for Free” option. This gives you access to 100 free tasks each month to explore the software. Existing users can simply sign in to access their dashboard.

2. Creating a Workflow in Pabbly Connect

Once you’re signed in to Pabbly Connect, the next step is to create a new workflow. Click on “Create from Scratch” to start building your workflow.

Select the trigger as “New or Updated Spreadsheet Row” from Google Sheets.
Choose the action as “Send Email” via Gmail.
Map the necessary fields for email generation.

After selecting these options, review your workflow setup and click on “Approve and Create” to finalize your workflow.

3. Setting Up Google Sheets with Pabbly Connect

To connect Google Sheets with Pabbly Connect, you need to add a new detail in your Google Sheet. This includes customer name, email address, product name, and offer details.

After adding the new details, go back to your Pabbly Connect dashboard. You will need to install the Pabbly Connect Webhook add-on in your Google Sheets account. Click on “Extensions”, then “Add-ons”, and search for “Pabbly Connect Webhook” to install it.

4. Testing the Integration Between Google Sheets and Gmail

Now that you have set everything up, it’s time to test the integration. In Pabbly Connect, you can send a test data from your Google Sheets to confirm the connection is successful.

Click on the “Send Test” button to send the first row of data from your Google Sheet to your Gmail account. Check your inbox to see if the email was received correctly.

Ensure the email subject and body are correct.
Verify that the sender name and email address are set properly.
Check that the email content is generated as expected.

If everything looks good, you have successfully set up the integration!

5. Conclusion

In conclusion, using Pabbly Connect allows you to seamlessly automate the process of generating HTML-coded emails from Google Sheets and sending them via Gmail. This integration enhances efficiency and saves time in your email marketing efforts.

With just a few simple steps, you can set up this powerful automation and improve your communication with customers effortlessly.