Author: Nitin Maheshwari

Learn how to automate user enrollment in LearnWorlds after Stripe payments using Pabbly Connect. Step-by-step guide for seamless integration. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

---

1. Setting Up Pabbly Connect Workflow for Stripe Payments

To enroll a user on a specific course in LearnWorlds after a Stripe payment, you need to start by accessing Pabbly Connect. This platform allows you to automate the entire process seamlessly.

First, create a new workflow by clicking on the ‘Create Workflow’ button in your Pabbly Connect dashboard. Name your workflow something descriptive, like ‘Stripe to LearnWorlds’. This will help you identify the workflow easily in the future.

---

2. Connecting Stripe to Pabbly Connect

In this step, you will connect your Stripe account to Pabbly Connect. This connection is crucial as it allows Pabbly Connect to receive payment details from Stripe.

Follow these steps to set up the connection:

• Select ‘Stripe’ as the app in the trigger section.
• Choose the trigger event as ‘Checkout Session Completed’.
• Copy the webhook URL provided by Pabbly Connect and add it to your Stripe account under the Webhooks section.

This setup ensures that every time a payment is completed, Pabbly Connect will receive the necessary details to proceed with the automation.

---

3. Testing the Stripe Payment and Receiving Data in Pabbly Connect

After setting up the Stripe connection, it’s time to test the payment process. This step verifies that Pabbly Connect is correctly receiving payment data from Stripe.

Make a test payment through the Stripe payment link you created earlier. Once the payment is made, Pabbly Connect will show a response indicating that it has received the payment details. Check for the payment link and customer information in the response.

If the payment link matches the one you set for the specific course, you can proceed to the next step. This confirms that Pabbly Connect is functioning as intended and ready to automate user enrollment.

---

4. Adding Filter Conditions in Pabbly Connect

To ensure that only customers who paid for the specific course are enrolled, you need to add a filter condition in Pabbly Connect. This step is essential for maintaining accurate enrollment.

Here’s how to set up the filter condition:

• Select ‘Filter’ as the action step in Pabbly Connect.
• Set the condition to check if the payment link matches the specific course link.
• Save the filter condition to continue with the workflow only if it is true.

This filter ensures that only the right customers are enrolled in their respective courses, enhancing the accuracy of your automation.

---

5. Enrolling Users in LearnWorlds via Pabbly Connect

Now that you have filtered the payments, it’s time to enroll the customer in LearnWorlds. This is the final step where Pabbly Connect plays a crucial role in automating user enrollment.

To enroll the user, follow these steps:

Select ‘LearnWorlds’ as the app in the action section. Choose the action event ‘Enroll User to a Product’. Map the user ID and product ID to enroll the customer in the correct course.

After setting this up, every time a payment is completed, Pabbly Connect will automatically enroll the customer in LearnWorlds, streamlining your workflow efficiently.

---

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate user enrollment in LearnWorlds after a Stripe payment. By following these steps, you can ensure a seamless integration that enhances your online course management.

Learn how to automate appointment reminders on WhatsApp using Pabbly Connect and Google Forms. Step-by-step tutorial for seamless integration. 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. Setting Up Pabbly Connect for Appointment Reminders

To automate appointment reminders using Pabbly Connect, start by logging into your Pabbly Connect account. If you don’t have an account, create one by clicking on the ‘Sign Up Free’ button. This integration will connect Google Forms with WhatsApp for sending reminders.

Once logged in, navigate to the dashboard and click on the blue button labeled ‘Create Workflow’. Here, name your workflow, for example, ‘Send Appointment Reminders via WhatsApp’. Click ‘Create’ to proceed and set up the trigger and action applications.

---

2. Selecting Google Forms as the Trigger Event

In the workflow setup within Pabbly Connect, select Google Forms as your trigger application. Choose the trigger event labeled ‘New Response Received’. This event will trigger whenever a new appointment is submitted through the Google Form.

After selecting the trigger event, you will receive a webhook URL. Copy this URL as it will be used to connect your Google Form to Pabbly Connect. Next, open the associated Google Sheets linked with your Google Form to set up the webhook.

• Open the Google Sheets linked to your Google Form.
• Click on Extensions, then Add-ons, and select ‘Get Add-ons’.
• Search for ‘Pabbly Connect Webhooks’ and install it.

After installation, return to the Extensions menu, select ‘Pabbly Connect Webhooks’, and click on ‘Initial Setup’. Paste the copied webhook URL here and set the trigger column to the last column of your data in the sheet. This setup ensures that whenever a new response is submitted, it will be sent to Pabbly Connect.

---

3. Testing the Webhook Connection

To test the webhook connection, fill out the Google Form with dummy details. For instance, enter a name, email, phone number, and appointment date. Submit the form to trigger the webhook and collect the data in the Google Sheet.

Once submitted, return to Pabbly Connect and check if the response data is received correctly. If successful, you will see the details populated in Pabbly Connect, confirming that the connection is working as intended.

• Ensure the data is recorded in the Google Sheet.
• Check for the presence of the timestamp and other details in Pabbly Connect.

Once the test data appears in Pabbly Connect, enable the ‘Send on Event’ option to ensure that new submissions automatically trigger the webhook.

---

4. Setting Up WhatsApp Reminders

After confirming the webhook connection, the next step is to set up WhatsApp reminders. To do this, add a new action step in Pabbly Connect and select the WhatsApp application for sending messages. Choose the action event ‘Send WhatsApp Message Template’.

Connect to the WhatsApp application by entering the required credentials, such as the secret key. This key can be obtained from the WhatsApp Cloud API. After connecting, map the phone number of the recipient and the message template you wish to send.

Map the recipient’s phone number from the Google Form submission. Enter the message template code and language. Ensure the template is approved in WhatsApp to send messages.

Once the mapping is complete, you can send a test message to verify if the reminders are being sent correctly via WhatsApp. Make sure to replace any dummy numbers with actual WhatsApp numbers for testing.

---

5. Finalizing the Automation Process

To finalize the automation process, ensure that all steps are properly configured in Pabbly Connect. You can add a delay step if you want the reminder to be sent one day before the appointment date. Use the delay function to set the timing.

Finally, review all the settings and ensure that the workflow is saved. Once everything is in place, your automation will send appointment reminders automatically to clients via WhatsApp whenever they submit an appointment request through Google Forms.

This integration not only saves time but also enhances customer experience by keeping them informed about their appointments. With Pabbly Connect, you can easily manage and automate this process without manual intervention.

---

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate appointment reminders on WhatsApp for Google Forms submissions. By following the steps outlined above, you can streamline your appointment management process effectively.

Automating reminders enhances communication and reduces no-shows, making it a valuable tool for any service-based business. Start integrating with Pabbly Connect today for seamless automation!

Learn how to add or update rows in Google Sheets from new Typeform responses using Pabbly Connect. This step-by-step guide covers everything you need to know.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Integration

To begin the integration process, you need to access Pabbly Connect. Start by typing the URL Pabbly.com/connect in your browser. Once on the landing page, you will see options to sign in or sign up for free. Existing users should click on ‘Sign In’, while new users can create an account in under two minutes.

After signing in, navigate to the dashboard where you will find various applications offered by Pabbly. Click on ‘Access Now’ for Pabbly Connect. This is the platform that will facilitate the integration between Typeform and Google Sheets.

---

2. Creating a New Workflow in Pabbly Connect

Once in Pabbly Connect, click on the ‘Create Workflow’ button. A dialog box will prompt you to name your workflow. For this tutorial, name it ‘Add or Update Row in Google Sheets from New Form Response’. Click ‘Create’ to proceed.

In the next window, you’ll see two main modules: Trigger and Action. The trigger application will be Typeform, and the action application will be Google Sheets. This setup allows you to automate the process of adding or updating rows based on new form responses.

• Select Typeform as the trigger application.
• Choose ‘New Entry’ as the trigger event.
• Connect your Typeform account by clicking ‘Connect’ and following the authorization steps.

After setting up the trigger, you will be ready to capture new responses from your Typeform.

---

3. Setting Up Typeform for New Responses

Next, you need to configure Typeform to collect responses. Go to your Typeform account and select the form you want to use. For this tutorial, we will use an ‘Appointment Form’ which includes fields like First Name, Last Name, Phone Number, and Email Address.

After confirming your form fields, return to Pabbly Connect. Enter the form name in the provided field and click ‘Save & Send Test Request’. This action will prompt you to submit a test response through Typeform.

• Publish your Typeform to get the link.
• Fill out the form with sample data.
• Submit the form to capture the response in Pabbly Connect.

Now, you will see the API response in Pabbly Connect, which confirms that the integration is working correctly.

---

4. Setting Up Google Sheets to Receive Data

After confirming the data from Typeform, the next step is to set up Google Sheets in Pabbly Connect. Select Google Sheets as your action application and choose the action event ‘Lookup Spreadsheet Row’. This will allow you to check if the response already exists in your Google Sheet.

Connect your Google Sheets account by clicking on ‘Connect’ and following the authorization process. Enter the name of the spreadsheet where you want to store the data, and select the appropriate sheet. The lookup column will be the email address, which is used to identify existing entries.

Input the spreadsheet name as ‘New Leads’. Set the lookup column to the email address. Map the lookup value to the email address from the Typeform response.

After setting this up, you will be able to determine whether to update an existing row or add a new one based on the email address.

---

5. Updating or Adding a Row in Google Sheets

Now that you have set up the lookup, you need to create conditions for updating or adding rows in Google Sheets. Use the router feature in Pabbly Connect to create conditions based on whether the email exists in the spreadsheet.

Create two routes: one for updating the contact if the email exists and another for adding a new contact if it does not. For the update route, select Google Sheets as the action application and choose ‘Update Row’ as the action event.

Map the row index from the lookup step. Map the first name, last name, email, and contact number from the Typeform response. For the add route, set up the action to add a new row with the same mapped fields.

After completing these steps, your integration will be fully functional, allowing you to automatically update or add rows in Google Sheets based on new Typeform responses.

---

Conclusion

In this tutorial, we explored how to integrate Typeform with Google Sheets using Pabbly Connect. By following the steps outlined, you can easily add or update rows in Google Sheets from new form responses. This integration streamlines your data management and enhances your workflow efficiency.

Learn how to create dynamic web pages and redirect users using form submission data with Pabbly Connect. Step-by-step tutorial for seamless integration. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect to Set Up the Integration

To begin, access Pabbly Connect by typing the URL Pabbly.com/connect in your browser. This platform serves as the central hub for integrating various applications, including Facebook and YouTube, to create dynamic web pages.

Once on the landing page, you can either sign in if you are an existing user or sign up if you are new. After signing in, navigate to the dashboard where you will find the option to create a workflow. Click on ‘Create Workflow’ and name it according to your project needs, such as ‘Dynamic Web Pages Creation’.

---

2. Setting Up the Trigger Application in Pabbly Connect

In this step, you will define the trigger application that initiates the workflow. The trigger application will be Elementor forms, which is essential for capturing form submissions. Select Elementor forms as your trigger application and choose the trigger event as ‘New Form Submission’.

• Select Elementor forms from the list of applications.
• Choose ‘New Form Submission’ as the trigger event.
• Copy the generated webhook URL provided by Pabbly Connect.

This webhook URL will be used to connect your Elementor form to Pabbly Connect. Ensure you copy this URL as it is crucial for the next steps of the integration.

---

3. Configuring Elementor Form to Work with Pabbly Connect

Next, you will configure your Elementor form to send data to Pabbly Connect. Go to your WordPress site and open the Elementor form you created for the live concert. Click on the form widget and navigate to the ‘Actions After Submit’ section.

• Add ‘Collect Submissions’ and ‘Redirect’ actions.
• Paste the webhook URL into the redirect field.
• Ensure to include form fields in the redirect URL for dynamic data.

By setting these actions, every time a user submits the form, their data will be sent to Pabbly Connect, and they will be redirected to a dynamic web page that you will create in the next steps.

---

4. Creating Dynamic Web Pages with Pabbly Connect

After configuring the form, the next step is to create dynamic web pages using Pabbly Connect. This involves using the ‘Dynamic Web Page’ feature of Pabbly to generate a unique URL for each submission. In the Pabbly Connect dashboard, choose the action application as ‘Dynamic Web Page by Pabbly’ and select the action event to generate a web page URL.

Input the necessary HTML content for the web page. This content can be customized to include user-specific data such as their name, table number, and a downloadable ticket link. You can map the fields from the previous steps to ensure that each user receives a personalized web page.

---

5. Finalizing Redirects Using Pabbly Connect

The last step involves finalizing the redirection process. In Pabbly Connect, add another action step and select ‘Data Forwarder’ as the application. Choose the redirect option and input the dynamic web page URL generated in the previous step.

Set the redirect status to 301 (moved permanently) to ensure that users are seamlessly redirected to their personalized page after form submission. Once you have saved and tested this workflow, you will see successful API responses confirming that the integration is complete.

---

Conclusion

In this tutorial, you learned how to use Pabbly Connect to create dynamic web pages and redirect users based on form submission data. By following these steps, you can automate the process of generating personalized experiences for your users efficiently.

Learn how to create dynamic web pages and redirect users using form submission data with Pabbly Connect in this step-by-step tutorial. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Dynamic Page Creation

To create dynamic web pages and redirect users using form submission data, start by accessing Pabbly Connect. Visit the URL Pabbly.com/connect to reach the landing page.

Here, you can either sign in if you’re an existing user or sign up if you are new. After logging in, navigate to the ‘All Applications’ page and click on ‘Access Now’ for Pabbly Connect. You will be directed to the dashboard where you can begin creating your workflow.

---

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, you can create a workflow to automate the process of generating dynamic web pages. Click on the ‘Create Workflow’ button on the right side of the dashboard. Name your workflow appropriately, such as ‘Dynamic Web Pages Creation and User Redirection’. using Pabbly Connect

• Choose the trigger application as Elementor Forms.
• Select the trigger event as ‘New Form Submission’.
• Click on ‘Connect’ to establish the connection.

Once you have set this up, you will receive a webhook URL that will be used to receive form submissions from Elementor Forms. Make sure to copy this URL for the next steps.

---

3. Setting Up Elementor Forms for User Input

Now, head over to your WordPress dashboard to set up the Elementor form that users will fill out. Navigate to the Elementor page editor and create a new form for your live concert. using Pabbly Connect

In the form settings, go to the ‘Actions After Submit’ section and add the actions to collect submissions and redirect users. Here, paste the webhook URL you copied earlier into the redirect field.

• Add form fields such as Name, Email, Mobile Number, and Message.
• Ensure that you configure the redirect URL to include query parameters for each field.
• Update the form settings after completing the setup.

This setup allows users to be redirected to a dynamic web page after submitting their information through the Elementor form. The data captured will be sent to Pabbly Connect.

---

4. Generating Dynamic Web Pages with Pabbly Connect

After users submit the form, the next step is to generate a dynamic web page for each user. In Pabbly Connect, add a new action step and select ‘Dynamic Web Page by Pabbly’ as the application. using Pabbly Connect

For the action event, choose ‘Generate Web Page URL’. You will need to provide the HTML content that will be displayed on the dynamic page. You can map the user’s name and the randomly generated table number in the HTML content.

Paste your HTML content into the designated field. Map the user’s name and table number using the data received from the previous steps. Save and send a test request to generate the dynamic web page URL.

Once this is completed, you will receive a dynamic web page URL that users will be redirected to after form submission.

---

5. Redirecting Users to Dynamic Pages Using Pabbly Connect

The final step is to redirect users to the newly created dynamic web page. In Pabbly Connect, add another action step and select ‘Data Forwarder by Pabbly’. Choose the action event as ‘Redirect To’. using Pabbly Connect

In the redirect URL field, paste the dynamic web page URL generated in the previous step. Set the redirect status to ‘301 Moved Permanently’ and save the action.

Ensure the redirect URL points to the dynamic web page created. Test the workflow to confirm that users are redirected correctly after form submission. Monitor the API responses to verify successful integration.

With this setup, users will receive a personalized dynamic web page link upon form submission, enhancing their experience during the live concert.

---

Conclusion

In this tutorial, we explored how to create dynamic web pages and redirect users using form submission data through Pabbly Connect. By integrating Elementor Forms with Pabbly Connect, users can receive personalized URLs after submitting their information, streamlining the process and improving user engagement.

Learn how to seamlessly integrate Stripe customers into MS Excel using Pabbly Connect with this step-by-step tutorial. Perfect for automating your customer records! Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

---

1. Setting Up Pabbly Connect for Stripe and Excel Integration

To integrate Stripe customers into MS Excel, you first need to set up Pabbly Connect. Start by signing into your Pabbly Connect account. Once logged in, navigate to your dashboard where you’ll find a prominent blue button labeled ‘Create Workflow’. Click on this button to begin creating your integration.

Next, name your workflow something descriptive, like ‘Add Stripe Customers to MS Excel’. After naming, click on the ‘Create’ button, and a blank workflow will be generated. This is where you will set up the trigger and action for your automation using Pabbly Connect.

---

2. Configuring the Stripe Trigger in Pabbly Connect

The next step involves setting up the trigger in Pabbly Connect. Your trigger application will be Stripe, specifically the event of a new customer being created. To do this, go to your Stripe account, click on ‘Developers’ at the top, and select ‘Webhooks’ from the options.

• Copy the webhook URL provided by Pabbly Connect.
• Paste this URL into the Stripe webhook settings.
• Set the event to ‘customer.created’ to trigger the workflow.
• Click ‘Add Events’ to finalize the webhook setup.

After setting up the webhook, you will see a message indicating that it’s waiting for a response. This means you need to create a new customer in Stripe to test the integration.

---

3. Adding a New Customer in Stripe

With the webhook set up, the next step is to add a new customer in Stripe. Go back to your Stripe dashboard, click on ‘Customers’, and select ‘Add Customer’. Fill in the required fields such as name, email address, and any other relevant details.

Once you have entered the customer details, click on the ‘Add Customer’ button. This action will trigger the webhook you set up earlier. As a result, Pabbly Connect will receive the customer information, which can now be used to populate your Excel sheet.

---

4. Configuring the MS Excel Action in Pabbly Connect

After successfully receiving the customer data in Pabbly Connect, it’s time to set up the action to add this information to MS Excel. Choose ‘Microsoft Excel’ as your action application and select the event ‘Add Row to Worksheet’.

• Connect your Microsoft Excel account to Pabbly Connect.
• Select the workbook where you want to add the customer details.
• Map the fields from the Stripe response to the corresponding columns in Excel.

Once you have mapped the fields, click on ‘Save and Send Test Request’. This will send the data to your Excel sheet, adding a new row with the customer details you just created in Stripe.

---

5. Verifying the Excel Integration

Finally, it’s time to verify that the integration works as expected. Go to your MS Excel workbook and refresh the page. You should see the new customer details populated in the designated columns, confirming that Pabbly Connect has successfully added the Stripe customer information.

This automation saves you the hassle of manually entering customer data into your Excel sheet, enhancing your workflow efficiency. You can now share this Excel sheet without compromising the security of your Stripe account credentials.

---

Conclusion

In this tutorial, we explored how to integrate Stripe customers into MS Excel using Pabbly Connect. By following these steps, you can automate the process of keeping track of your customers efficiently. This integration not only streamlines your workflow but also ensures that sensitive information remains secure.

Learn how to automate saving specific Google Drive file links to Google Sheets using Pabbly Connect. Step-by-step guide for seamless integration. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

---

1. Setting Up Pabbly Connect for Google Drive and Google Sheets Integration

To save specific Google Drive file links to Google Sheets, you need to use Pabbly Connect. Begin by logging into your Pabbly Connect account. Once logged in, click on the ‘Create Workflow’ button to start a new integration process.

Next, name your workflow and click on the create button. You will be directed to a workflow page where you will find two modules: the trigger and the action. The trigger will be set up to detect new files uploaded in a specific Google Drive folder.

---

2. Configuring Google Drive as the Trigger Application

In this step, select Google Drive as your trigger application in Pabbly Connect. Choose the trigger event as ‘New File in Specific Folder’. Click on the connect button and select ‘Add New Connection’.

Sign in with your Google account that has access to the Google Drive folder where you will upload files. After authorization, select the specific folder (e.g., ‘Team Files’) where you will be uploading Excel files. Once selected, click on ‘Save and Send Test Request’ to verify the connection.

• Select Google Drive as the application.
• Choose ‘New File in Specific Folder’ as the trigger event.
• Connect your Google account.
• Select the folder where files will be uploaded.

After the test request, you will receive a response showing the last uploaded file details, including its link and title, which is essential for the next steps in your automation.

---

3. Applying Filters to Ensure Specific File Types Are Saved

To ensure only specific file types (like Excel files) are saved to Google Sheets, you will use a filter step in Pabbly Connect. Add a filter by selecting the ‘Filter by Pabbly’ option. Set the filter condition to check if the file extension is equal to ‘xlsx’.

Map the file extension from the previous step into the filter condition. Click on ‘Save and Send Test Request’ to check if the condition is true. If the condition is met, the workflow will proceed to the next step, allowing the data to be sent to Google Sheets.

• Select ‘Filter by Pabbly’ as the action step.
• Set the condition to check file extension.
• Map the file extension from the trigger step.
• Test the filter condition.

Once the filter is successfully validated, you are ready to send the data to Google Sheets.

---

4. Sending Data to Google Sheets Using Pabbly Connect

In this step, select Google Sheets as the action application in Pabbly Connect. Choose the action event as ‘Add New Row’. Click on the connect button and select ‘Add New Connection’ to connect your Google account again.

After connecting, select the spreadsheet (e.g., ‘Google Drive Files’) where you want the data to be stored. Map the file name and file link fields to the corresponding headers in your Google Sheet. Ensure that you map the correct values from the previous steps.

Select Google Sheets as the action application. Choose ‘Add New Row’ as the action event. Map the file name and file link to the spreadsheet columns. Test the action to ensure data is added correctly.

After testing, you should see a new row added in Google Sheets with the file name and the downloadable link.

---

5. Conclusion: Automate Your Google Drive to Google Sheets Workflow

By using Pabbly Connect, you can automate the process of saving specific Google Drive file links to Google Sheets effortlessly. This integration allows you to save time by eliminating manual data entry, ensuring that every time you upload an Excel file, its details are automatically stored in your designated Google Sheet.

Now you can easily manage your files and links in one place without any hassle. Set up this automation once, and it will work seamlessly every time you upload a new file.

With Pabbly Connect, integrating various applications becomes a breeze, enabling you to focus on more important tasks while the automation takes care of the data management.

---

Learn how to automate adding live items to Webflow collections using Excel sheets with Pabbly Connect. Step-by-step tutorial for seamless integration. 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 Excel and Webflow Integration

To automate adding live items in Webflow using Excel sheets, you first need to set up Pabbly Connect. Begin by visiting the Pabbly Connect landing page where you can sign up for free. Once signed up, log into your account to access the dashboard.

On the dashboard, click the ‘Create Workflow’ button to start building your automation. Name your workflow appropriately, for example, ‘Webflow Live Items from Excel’. After naming, click the ‘Create’ button to load the workflow page where you can set up triggers and actions.

---

2. Setting Up Microsoft Excel as the Trigger in Pabbly Connect

In this section, you will configure Microsoft Excel as the trigger application in Pabbly Connect. Start by selecting ‘Microsoft Excel’ from the list of applications. Choose the trigger event as ‘New Row in Worksheet’. This means that whenever a new row is added to your Excel sheet, it will trigger the workflow.

• Select ‘Add New Connection’ to connect your Microsoft Excel account.
• Authorize access by selecting your Microsoft account and clicking ‘Yes’ to grant permissions.
• Choose the workbook name, for example, ‘Webflow Design’ and the sheet name, which is typically ‘Sheet1’.

After setting this up, click on the ‘Save and Send Test Request’ button. This will fetch the last row added to your Excel sheet as test data, which will be crucial for the next steps.

---

3. Configuring Webflow as the Action Application

Now that you have set up Microsoft Excel as the trigger, the next step is to configure Webflow as the action application in Pabbly Connect. Search for Webflow in the action application field and select it. The action event you need to choose is ‘Create Live Item’.

Click on the ‘Connect’ button, and select ‘Add New Connection’. You will need to input your Webflow API token, which can be obtained from your Webflow project settings under the Integrations tab. Generate a new token if you do not have one already and paste it into Pabbly Connect.

Once connected, you will be prompted to select your Webflow site and the specific collection where you want to add the live items. Ensure you select the appropriate collection, such as ‘Blog Posts’.

---

4. Mapping Data from Excel to Webflow Fields

With the connection established, it’s time to map the data from your Excel sheet to the corresponding fields in Webflow using Pabbly Connect. Utilize the test data fetched from Excel to fill in the required fields in Webflow.

• Map the image URL from Excel to the main image field in Webflow.
• Fill in the blog post content using the text data received from Excel.
• Set the slug, archived, and draft fields according to your preferences (e.g., false for published items).

After mapping the fields correctly, click on the ‘Save and Send Test Request’ button to verify the connection and ensure that the live item is created in Webflow.

---

5. Finalizing the Automation Process

After successfully testing the connection and ensuring that the live items are created in Webflow, your automation process is complete with Pabbly Connect. This automation will continuously check for new data in your Excel sheet every eight hours and automatically create new blog posts in Webflow as you add rows to your Excel sheet.

To see the live updates, refresh your Webflow blog page, and you should see the newly created entries. This seamless integration saves you time and effort in managing your website content.

Remember, you only need to set up this automation once, and it will run automatically in the background, enhancing your workflow efficiency.

---

Conclusion

In this tutorial, you learned how to integrate Excel sheets with Webflow using Pabbly Connect. This automation simplifies adding live items to your Webflow collections, saving time and effort in content management.

Learn how to automate sending brochures via email upon Google Form submissions using Pabbly Connect. Step-by-step guide for seamless integration. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

---

1. Setting Up Pabbly Connect for Google Forms and Gmail Integration

To automate sending brochures via email when a Google Form is submitted, you will need to set up Pabbly Connect. First, log in to your Pabbly Connect account. If you don’t have an account, you can create a free one in just a few minutes. Once logged in, navigate to your dashboard.

Click on the blue button labeled ‘Create Workflow’ and give your workflow a name, such as ‘Send Brochure on Google Form Submission’. This name helps you identify the automation later. After naming your workflow, click on the ‘Create’ button to proceed.

---

2. Choosing Google Forms and Gmail in Pabbly Connect

In this step, you need to select the applications involved in your automation. Since we are using Pabbly Connect to integrate Google Forms and Gmail, select Google Forms as the trigger application and Gmail as the action application. The trigger signifies when an event occurs, while the action specifies what should happen next.

• Select ‘Google Forms’ as the trigger application.
• Choose ‘New Response Received’ as the trigger event.
• Select ‘Gmail’ as the action application.
• Choose ‘Send Email’ as the action event.

After selecting these applications, you will be guided to connect them through Pabbly Connect. This connection is crucial as it allows the automation to function seamlessly.

---

3. Configuring Google Forms to Trigger Pabbly Connect

To link your Google Form with Pabbly Connect, you need to set up a webhook. After selecting Google Forms, you will receive a webhook URL. Copy this URL, as it is essential for the integration process.

Next, open the Google Sheets associated with your Google Form. Click on ‘Extensions’, then ‘Add-ons’, and select ‘Get Add-ons’. Search for the ‘Pabbly Connect Webhooks’ add-on and install it if you haven’t done so already. Once installed, go back to the Google Sheets, click on ‘Extensions’, and find the Pabbly Connect add-on to set it up.

• Click on ‘Initial Setup’ in the Pabbly Connect add-on.
• Paste the copied webhook URL into the designated field.
• Set the trigger column as the final data column (e.g., column D).

After completing these steps, you can test the webhook by submitting a dummy response through your Google Form. This will send the test data to Pabbly Connect, confirming that the setup is correct.

---

4. Setting Up Gmail to Send the Brochure

Now that your Google Form is connected to Pabbly Connect, it’s time to configure Gmail to send the brochure. In the action step of your workflow, select Gmail and choose ‘Send Email’ as the action event. You’ll need to connect your Gmail account to Pabbly Connect if you haven’t done so already.

When prompted, authorize Pabbly Connect to access your Gmail account. After connecting, you will need to fill in several fields, including the recipient’s email address, subject line, and email body. For the recipient’s email, map the email address collected from the Google Form submission.

Input a sender name, such as ‘Pabbly Brochure Agency’. Create a subject that includes the recipient’s name for personalization. Write a friendly email body and include a link to the brochure.

Once all details are filled in, click on ‘Save and Send Test Request’. This will send a test email to verify that everything is working correctly.

---

5. Finalizing Your Automation with Pabbly Connect

After successfully testing your email setup, your automation is almost complete. Ensure that the settings in the Pabbly Connect workflow are correctly configured. You need to enable the option to send data on event, which allows Pabbly Connect to automatically send the email every time a new response is received.

To finalize, check the settings in your Google Sheets add-on to ensure that the automation will trigger correctly. Test the entire process by submitting another response through your Google Form. If everything is set up correctly, you should receive the brochure email automatically.

Once this integration is live, you can relax knowing that Pabbly Connect will handle sending brochures to your customers automatically whenever they fill out your Google Form. This automation saves time and ensures a seamless customer experience.

---

Conclusion

In this tutorial, we demonstrated how to automate sending a brochure via email using Pabbly Connect upon Google Form submissions. By following these steps, you can streamline your communication process and enhance customer engagement effortlessly.

Learn how to seamlessly connect forms.app with Airtable using Pabbly Connect to automate form responses and enhance your workflow. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Integration

To integrate forms.app with Airtable, you need to access Pabbly Connect. Start by signing up for a free account on the Pabbly Connect dashboard. You can find the signup link in the description below.

Once you are logged into your Pabbly Connect account, click on the ‘Create Workflow’ button. Name your workflow, for example, ‘forms.app to Airtable’, and click on ‘Create’. This sets up the foundation for your automation.

---

2. Setting Up the Trigger with forms.app

The first step in your workflow is to set up the trigger. In the trigger window, search for Pabbly Connect and select ‘forms.app’ as your app. Choose ‘New Form Submission’ as the trigger event.

• Select ‘New Form Submission’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.
• Go to your forms.app account and edit the form you want to connect.

In forms.app, navigate to the ‘Connect’ section and click on ‘Webhook’. Here, paste the copied webhook URL and save the changes. This establishes the connection between forms.app and Pabbly Connect.

---

3. Testing the Trigger with a Sample Submission

After setting up the webhook, it’s time to test the connection. Go back to your forms.app and submit a test form. Enter details like ‘Demo User’ for the name, an email address, and a mobile number, then click ‘Submit’.

Once the submission is made, return to Pabbly Connect. You will see that it is now waiting for a webhook response. If successful, you should see the details of your test submission appear in the trigger window.

---

4. Adding Airtable as an Action in Pabbly Connect

Next, set up the action to send the form responses to Airtable. In the action window, search for Pabbly Connect and select ‘Airtable’ as the app. Choose ‘Create Record’ as the action event.

To connect your Airtable account, you will need your API token. Go to your Airtable account, click on your account button, and navigate to the Developer Hub to create a new token. Ensure to give it all required permissions as outlined in the help text.

• Create a new token in Airtable with the necessary scopes.
• Copy the API token and paste it back into Pabbly Connect.
• Select the base and table where you want to add the form responses.

After configuring these settings, map the fields from your form submission to the corresponding fields in Airtable. This ensures that the data is accurately transferred.

---

5. Finalizing the Integration and Testing

Once you have mapped all necessary fields, click on ‘Save and Send Test Request’ in Pabbly Connect. This will send the test data to Airtable. If successful, you will receive a confirmation response.

Check your Airtable to see if the new record has been created with the test submission details. If everything looks good, your automation is now complete. You can test it further by submitting more forms from forms.app.

This integration allows you to automate the process of adding form responses directly into Airtable, saving you time and effort. With Pabbly Connect, you can seamlessly connect various applications for enhanced productivity.

---

Conclusion

Integrating forms.app with Airtable using Pabbly Connect automates the process of adding form responses into your Airtable database. This setup enhances efficiency and streamlines your workflow.