Integrate Your Favorite Apps in Minutes with Pabbly Connect

Learn how to seamlessly connect Google, Google Sheets, and Mailchimp using Pabbly Connect in this step-by-step tutorial. No tech skills required! Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect to Start Integrating Your Apps

To begin using Pabbly Connect, visit the official site by searching for Pabbly.com/connect. Here, you will find options to sign in or sign up for a free account. If you are new, click on ‘Sign up free’ to get started with 100 free tasks each month.

Once signed in, navigate to the ‘Pabbly Apps’ window. Click on the ‘Access Now’ button for Pabbly Connect. This will take you to the dashboard where you can create workflows to connect your favorite applications seamlessly.

2. Create a Workflow in Pabbly Connect

To set up your automation, click on the ‘Create Workflow’ button in Pabbly Connect. You will be prompted to choose between the new beta version and the classic version. For this tutorial, select the beta version for a more modern experience.

• Click on the ‘Create Workflow’ button.
• Name your workflow, e.g., ‘Connect Your Favorite Apps in Minutes No Tech Skills’.
• Select the appropriate folder for your workflow.

After naming your workflow, you can begin setting up the trigger and action steps. Remember, each automation in Pabbly Connect consists of a trigger (what starts the process) and actions (what happens as a result).

3. Set Up Trigger with Facebook Lead Ads

For this integration, the trigger will be new leads generated from Facebook Lead Ads. In Pabbly Connect, select Facebook Lead Ads as your trigger application and choose the event ‘New Lead Instant’.

To connect your Facebook account, click on ‘Connect’ and follow the prompts to authorize Pabbly Connect. After successful connection, select your Facebook page and the specific lead generation form you wish to use.

• Select your Facebook page (e.g., Digital Dynamics).
• Choose the lead generation form you have created.

Once you have set up the trigger, click on ‘Save and Send Test Request’ to ensure everything is working correctly. This will allow you to receive a test lead for further processing.

4. Add New Lead to Google Sheets

After successfully capturing the lead from Facebook, the next step is to add this information to Google Sheets. In Pabbly Connect, select Google Sheets as your action application and choose the event ‘Add New Row’.

Click on ‘Connect’ to link your Google Sheets account. Select your specific spreadsheet and the sheet where you want to add the new row. You will then map the fields from the Facebook lead to the corresponding columns in Google Sheets.

Map the first name, last name, email, and phone number fields. Ensure all required fields are filled in before saving.

Once done, click on ‘Save and Send Request’ to verify that the lead details are successfully added as a new row in your Google Sheets.

5. Create a New Subscriber in Mailchimp

The final step in this automation is to add the captured lead as a new subscriber in Mailchimp. Again, in Pabbly Connect, select Mailchimp as your action application and choose the event ‘Add New Member with Custom Fields’.

Connect your Mailchimp account by entering the required API key and data center. Once connected, you will select the audience list where the new subscriber will be added.

Map the email address, first name, last name, and mobile number fields. Set the subscription status to ‘subscribed’ for the new member.

After mapping all fields, click on ‘Save and Send Request’ to finalize the process. You can then check your Mailchimp account to confirm that the new subscriber has been added successfully.

Conclusion

This tutorial demonstrates how to integrate Facebook Lead Ads, Google Sheets, and Mailchimp using Pabbly Connect effortlessly. By following these steps, you can automate your lead management process without any technical skills required. Start connecting your favorite apps today!