Automate Ebook Delivery for Reviews via Google Forms & Email Using Pabbly Connect

Learn how to automate ebook delivery for reviews using Pabbly Connect, Google Forms, and SMTP. This step-by-step guide covers the entire integration process. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Ebook Delivery

To automate ebook delivery for reviews, we will use Pabbly Connect as our integration platform. Start by signing into your Pabbly Connect account. If you are a new user, you can sign up for free and get 100 tasks every month to use.

Once logged in, navigate to the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button located at the top right corner. You will need to name your workflow, for example, ‘Automate Ebook Delivery for Reviews via Google Forms and Email,’ and select a folder to save it in.

2. Integrating Google Forms with Pabbly Connect

The next step is to set up Google Forms as the trigger application in Pabbly Connect. Click on the trigger section and select Google Forms as the application. For the trigger event, choose ‘New Response Received’ to capture form submissions.

• Select Google Forms as the trigger application.
• Choose ‘New Response Received’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Now, open your Google Forms and go to the responses tab. Click on ‘Link to Sheets’ and create a new spreadsheet to store the responses. This spreadsheet will be connected to Pabbly Connect using the webhook URL you copied earlier.

3. Configuring Webhook with Google Sheets

To connect the Google Sheets to Pabbly Connect, click on ‘Extensions’ in your Google Sheets, then navigate to ‘Add-ons’ and search for ‘Pabbly Connect Webhooks.’ If it’s not installed, install it first.

Once installed, go back to ‘Extensions’ and select ‘Pabbly Connect Webhooks’ and then click on ‘Initial Setup.’ Paste the webhook URL you copied earlier and set the trigger column as the final data column where responses will be entered.

• Paste the webhook URL in the setup dialog.
• Select the trigger column, typically the last column with responses.
• Enable ‘Send on Event’ to ensure data is sent to Pabbly Connect.

After completing the setup, ensure that the webhook is successfully configured. This will allow Pabbly Connect to capture responses from Google Forms in real-time.

4. Filtering Responses for Ebook Delivery

Now that we have connected Google Forms to Pabbly Connect, we need to set up a filter to determine which clients will receive the ebook. In Pabbly Connect, add a new action step and select ‘Filter by Pabbly’ as the application.

Set the filter condition to check if the rating provided in the feedback is greater than 6. This ensures that only clients who rate their experience positively will receive the ebook. Click on ‘Save’ after setting the filter.

Choose ‘Filter by Pabbly’ as the action application. Set the filter condition to ‘Rating > 6’. Click ‘Save’ to finalize the filter setup.

This filtering process is crucial as it determines the recipients of the ebook based on their feedback ratings.

5. Sending the Ebook via SMTP

For the final action step, we will use SMTP by Pabbly to send the ebook to clients who meet the filter criteria. Select ‘SMTP by Pabbly’ as the action application and choose ‘Send Email’ as the action event. using Pabbly Connect

In the SMTP configuration, fill in the required fields such as sender name, sender email, recipient email (mapped from the previous step), subject, and body of the email. The email body should include a thank you message and a link to download the ebook.

After filling in all the necessary details, click on ‘Save’ and send a test request to ensure everything is working correctly. If successful, you should see a confirmation message indicating that the email has been sent.

Conclusion

In this tutorial, we demonstrated how to automate ebook delivery for reviews using Pabbly Connect, Google Forms, and SMTP. By setting up a seamless integration, you can easily send ebooks to clients who provide positive feedback, enhancing your review marketing automation efforts.