Automate eBook Delivery with Pabbly Connect: Google Forms to Gmail Integration

Learn how to automate eBook delivery using Pabbly Connect by integrating Google Forms with Gmail. Follow this step-by-step tutorial for seamless automation. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating eBook delivery, access Pabbly Connect. This platform allows you to integrate various applications seamlessly. Begin by visiting the Pabbly Connect website and signing in to your account.

If you are new to Pabbly Connect, you can sign up for free and get 100 tasks every month. After logging in, you will see the dashboard, where you can select Pabbly Connect to create your workflow.

2. Creating a Workflow in Pabbly Connect

To create a workflow in Pabbly Connect, click on the ‘Create Workflow’ button located at the top right corner of the dashboard. A dialog box will appear asking for a workflow name.

Enter a name like ‘Share eBooks on Google Form Submission’ and select a folder to save your workflow. After selecting the folder, click on ‘Create’ to set up your workflow. You will see two sections: Trigger and Action, which are essential for the automation process.

• Trigger: This initiates the workflow when a new form submission occurs.
• Action: This defines what happens after the trigger, such as sending an email via Gmail.

Now that your workflow is created, you can move on to setting up the trigger for Google Forms.

3. Setting Up Google Forms as Trigger

In Pabbly Connect, select Google Forms as your trigger application. Choose the trigger event as ‘New Response Received’. This means that every time a new form submission occurs, Pabbly Connect will capture the response.

After selecting the trigger, Pabbly Connect will provide you with a webhook URL. Copy this URL, as you will need it to connect Google Forms with Pabbly Connect.

• Open your Google Form and navigate to the Responses tab.
• Click on ‘Link to Sheets’ to create a new spreadsheet for form responses.
• Install the Pabbly Connect Webhooks add-on in Google Sheets.

Once the add-on is installed, you can set up the webhook URL in Google Sheets to ensure that responses are sent to Pabbly Connect.

4. Configuring Google Sheets for Webhooks

After linking Google Forms with a new Google Sheets spreadsheet, you need to configure it to work with Pabbly Connect. Click on ‘Extensions’ in the Google Sheets menu, then select ‘Pabbly Connect Webhooks’ and choose ‘Initial Setup’.

Paste the webhook URL you copied from Pabbly Connect into the dialog box. Set the trigger column to the final data column in your spreadsheet, which is typically Column E.

Click on ‘Submit’ to save the configuration. Ensure to select ‘Send on Event’ to trigger the webhook whenever a new response is added.

After configuring the webhook, you can return to Pabbly Connect and check if it’s ready to capture responses from Google Sheets.

5. Setting Up Gmail as Action

With the trigger set up, it’s time to configure the action in Pabbly Connect. Select Gmail as your action application and choose the action event as ‘Send Email’. This action will send an email with the eBook attachment to the customer.

Click on ‘Connect’ to authorize your Gmail account. Once authorized, you will need to fill in the recipient’s email address, which you can map from the previous Google Forms response.

Enter the sender’s name, email subject, and content. Attach the eBook file link that you want to send.

After filling all the necessary details, click on ‘Save and Send Test Request’. Check your Gmail account to confirm that the email with the eBook attachment has been successfully sent.

Conclusion

This tutorial demonstrated how to automate eBook delivery using Pabbly Connect by integrating Google Forms with Gmail. By following the steps outlined, you can streamline your eBook order process efficiently.