Learn how to integrate Divine Glamour with Google Sheets and Gmail to automate personalized marketing emails Using Pabbly Connect. Follow this step-by-step tutorial for seamless automation. with Pabbly Connect.

Watch Step By Step Video Tutorial Below

1. Setting Up Integration Between Divine Glamour and Google Sheets

To automate personalized marketing emails, we need to set up a connection between Divine Glamour and Google Sheets. Start by logging into your account on Make, which allows seamless integration without any coding skills.

After logging in, navigate to the dashboard and create a new workflow. Click on the ‘Create Workflow’ option, name it ‘Automate Personalized Marketing Emails’, and select the appropriate folder for your workflow. This organization helps keep your tasks streamlined.

2. Configuring Trigger and Action for Email Automation

For our automation, we will use a trigger and action setup. The trigger will be a schedule that runs every day at a specific time. Click on ‘Add Trigger’ and select ‘Schedule by Make’. Set it to run daily at 9:00 AM. using Pabbly Connect

  • Choose ‘Every Day’ as the frequency.
  • Set the time to 9:00 AM.

After configuring the trigger, add an action to fetch the current date. Select ‘Date Time Formatter’ as the action application. Set the action event to ‘Current Date’ and choose the desired date format.

3. Fetching Customer Data from Google Sheets

Next, we need to fetch customer data from Google Sheets. Add another action step and select Google Sheets as the application. Choose ‘Lookup Spreadsheet Row’ as the action event. This allows us to search for customer birth dates. using Pabbly Connect

Connect your Google Sheets account and select the spreadsheet containing customer data. Ensure the spreadsheet has columns for customer names, emails, and birth dates. Map the lookup column to the column that contains the birth dates.

  • Select the spreadsheet name.
  • Map the lookup value to the current date.

Once the data is fetched, you can check if any customers have their birthdays on that day. This step is crucial for sending personalized emails.

4. Sending Personalized Emails via Gmail

After confirming the birthdays, it’s time to send personalized emails using Gmail. Add another action step and select Gmail as the application. Choose ‘Send Email’ as the action event. using Pabbly Connect

Connect your Gmail account and map the recipient’s email address from the customer data retrieved earlier. Personalize the email by including the customer’s name in the email body.

Set the email subject to ‘Happy Birthday!’ Craft a personalized message offering a discount.

Finally, test the workflow to ensure emails are sent correctly. You should receive a confirmation that the email was sent successfully.

5. Workflow Summary and Benefits

In this workflow, we integrated Divine Glamour with Google Sheets and Gmail to automate sending birthday emails. The process involved setting up a trigger, fetching data from Google Sheets, and sending personalized emails through Gmail.

This automation not only saves time but also enhances customer engagement by sending timely birthday wishes. By Using Pabbly Connect, you can easily manage these tasks without needing technical skills.

With this setup, you can ensure that every customer at Divine Glamour receives their special birthday discount, fostering loyalty and satisfaction.

Conclusion

This guide summarizes the key points and helps you understand the essential features and benefits of using this tool.

Thanks for following along with this tutorial! Remember to subscribe to the channel for more helpful content like this.

If you found this guide useful, please consider giving it a thumbs up and sharing it with others who might benefit from it.

In conclusion, integrating Divine Glamour with Google Sheets and Gmail through Make allows you to automate personalized marketing emails efficiently. This setup enhances customer relationships while saving valuable time in your marketing efforts.