Author: Rajpal Tomar

Learn how to automate user enrollment in Nish courses using PHP and Google Sheets through Pabbly Connect in this detailed tutorial. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

---

1. Setting Up Nish Integration with Google Sheets

To begin with the Nish integration, we will use Google Sheets as our trigger application. The goal is to enroll users in a Nish course whenever new data is added to Google Sheets. using Pabbly Connect

First, sign in to your Pabbly Connect account. If you’re a new user, you can click on the ‘Sign Up for Free’ button to create an account and receive 100 free tasks. Once logged in, click on ‘Access Now’ to reach the dashboard.

---

2. Creating a Workflow in Pabbly Connect

After reaching the dashboard, click on the ‘Create Workflow’ button. Name your workflow something descriptive, like ‘Enroll User in Nish Course from Google Sheets’. Click ‘Create’ to proceed. using Pabbly Connect

Next, we will set up our trigger application. Search for Google Sheets and select it. Choose the trigger event as ‘New or Updated Spreadsheet Row’. This will activate the workflow whenever a new row is added or updated in your Google Sheets.

• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the provided webhook URL for further use.

After setting up the trigger, you will see a webhook URL. This URL connects Google Sheets with Pabbly Connect. Copy this URL to use it in your Google Sheets setup.

---

3. Connecting Google Sheets to Pabbly Connect

Open your Google Sheets where you manage user data. Ensure your spreadsheet contains columns for first name, last name, email, phone, and course name. Go to ‘Extensions’, then select ‘Pabbly Connect Webhooks’. If you haven’t installed the Pabbly Connect Webhooks add-on, you can find it in the ‘Get Add-ons’ section. using Pabbly Connect

Once installed, click on ‘Pabbly Connect Webhooks’ and select ‘Initial Setup’. Here, paste the webhook URL you copied earlier. Set the trigger column to the final data column in your spreadsheet, which is column E in this case.

• Select the appropriate sheet (Sheet 1).
• Paste the webhook URL into the designated field.
• Set the trigger column to E for capturing data.

After submitting, refresh your Google Sheets. Now, every time a new row is added, the data will be captured by Pabbly Connect.

---

4. Filtering Users for Advanced PHP Course

Now that we have connected Google Sheets with Pabbly Connect, we need to filter the users who are enrolling in the specific course, which is the Advanced PHP course. Go back to Pabbly Connect and add a filter action. using Pabbly Connect

Select the response you received earlier from Google Sheets and set the condition to check if the course name equals ‘Advanced PHP’. If the condition is true, the automation will proceed to the next step.

Select the course name from the previous response. Set the filter type as ‘Equal To’. Paste the course name ‘Advanced PHP’ into the value field.

Click ‘Save and Send Test Request’. If the condition is true, the automation will proceed to enroll the user in the Nish course.

---

5. Enrolling Users in Nish Course

For the final step, we will enroll the user in the Nish course. Search for Nish in the action application and select it. Choose the action event as ‘Add User to a Course’. This will allow you to add the captured user to the specified course. using Pabbly Connect

Next, establish a connection between Nish and Pabbly Connect by entering the required webhook URL and API key found in your Nish account under settings. After saving the connection, you will map the user data from Google Sheets to Nish.

Map the first name and last name from the previous response. Enter the email ID and phone number as mapped fields. Paste the course ID for the PHP course for beginners.

Click ‘Save and Send Test Request’ to complete the process. You can verify the enrollment by checking the All Users section in your Nish account to see the newly added user.

---

Conclusion

This tutorial demonstrated how to automate user enrollment in Nish courses using Google Sheets and Pabbly Connect. By following these steps, you can efficiently manage course enrollments with minimal manual effort.

Learn how to integrate Microsoft Power BI with webhook responses using Pabbly Connect. Follow this step-by-step guide for seamless automation. 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. Setting Up Pabbly Connect for Microsoft Power BI Integration

To add Microsoft Power BI records from a webhook response, you need to start by accessing Pabbly Connect. This platform enables you to automate workflows between various applications without any coding required. First, log in to your Pabbly Connect dashboard and click on the ‘Create Workflow’ button on the right side.

In the dialog box that appears, you should name your workflow something descriptive, like ‘Add Microsoft Power BI Records from Webhook Response’. After naming it, click on the ‘Create’ button to proceed to the next step where you’ll set up the trigger and action applications.

---

2. Configuring the Webhook Trigger in Pabbly Connect

In this step, you will configure the webhook trigger in Pabbly Connect. Select the ‘Webhook by Pabbly’ module as your trigger application. This module allows you to receive responses from applications that do not have a direct integration with Pabbly Connect.

• Choose ‘Webhook’ as the trigger event.
• Copy the generated webhook URL.
• Integrate this URL into the application from which you want to receive data.

Next, perform a test submission on the application to ensure that the data is captured correctly in Pabbly Connect. Once the test is successful, you will see the webhook response captured in the dashboard.

---

3. Adding Data to Microsoft Power BI from Webhook Response

After capturing the webhook response, the next step is to set Microsoft Power BI as your action application in Pabbly Connect. Select ‘Microsoft Power BI’ as your action application and choose the action event as ‘Add Rows in Specific Dataset in Group’. This action will allow you to add the captured data to a specified dataset in Power BI.

To connect your Microsoft Power BI account, click on the ‘Connect’ button, and authorize Pabbly Connect to access your Power BI account. After successful authorization, you will need to enter the Group ID and Dataset ID where the data will be stored. Make sure to create a dataset in Power BI that matches the fields you want to populate.

---

4. Mapping Data Fields for Microsoft Power BI

In this section, you will map the data fields from the webhook response to the dataset in Microsoft Power BI using Pabbly Connect. Ensure that the fields in your Power BI dataset correspond to the data you are receiving from the webhook.

• Map the first name, last name, email address, mobile number, and city fields.
• Use the correct format for JSON objects as required by Power BI.
• Ensure that all mapped fields are enclosed in double quotes.

After mapping, click on ‘Save and Send Test Request’ to send the data to Microsoft Power BI. Verify in Power BI that the data has been successfully added to your dataset.

---

5. Testing and Verifying the Integration

Now that you have set up the integration using Pabbly Connect, it’s time to test it. Go back to the application from which you are receiving webhook responses and submit another test entry. This will allow you to ensure that the entire process is functioning correctly.

Once you submit the data, check your Microsoft Power BI account to confirm that the new record appears in the dataset. This verification step is crucial to ensure that your integration works seamlessly and that all data is being captured as intended.

---

Conclusion

In this tutorial, we explored how to add Microsoft Power BI records from a webhook response using Pabbly Connect. By following the detailed steps outlined, you can automate data entry into Power BI, enhancing your reporting capabilities and data analysis.

Learn how to seamlessly integrate BigCommerce order details into Microsoft Power BI using Pabbly Connect for automated reporting and analysis. 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. Setting Up Pabbly Connect for Integration

To integrate BigCommerce with Microsoft Power BI, we will utilize Pabbly Connect. This powerful integration tool allows you to automate tasks between applications without any coding knowledge. First, log into your Pabbly Connect account or create a free account if you haven’t done so already.

Once logged in, navigate to your Pabbly Connect dashboard. Click on the blue button labeled ‘Create Workflow’ and name your workflow something like ‘Add BigCommerce Order Details to Microsoft Power BI.’ Click on ‘Create’ to proceed.

---

2. Creating a Trigger for New Orders in BigCommerce

In this step, we will set up the trigger to capture new orders from BigCommerce using Pabbly Connect. Select BigCommerce as your trigger application and choose the trigger event ‘New Order Created.’ This means that every time a new order is placed, Pabbly Connect will capture the details for further processing.

• Select BigCommerce from the application list.
• Choose the trigger event ‘New Order Created.’
• Click on ‘Connect’ to establish the connection.

After connecting, Pabbly Connect will prompt you to create an API key in your BigCommerce store. Follow the instructions to generate the key, which includes setting permissions for accessing orders and customer information. Once the API key is created, copy it and paste it back into Pabbly Connect to complete the setup.

---

3. Capturing Order Details from BigCommerce

After setting up the trigger, it’s time to capture the order details through Pabbly Connect. Click on the ‘Save and Send Test Request’ button. This action will prompt you to create a test order in your BigCommerce store to generate a response.

Place a dummy order in your BigCommerce store and ensure it has the necessary details such as customer name, email, and product information. Once the order is placed, return to Pabbly Connect, and you will see that the order details have been captured successfully. This includes the order ID, customer information, and product details.

---

4. Sending Data to Microsoft Power BI Using Pabbly Connect

Now that we have captured the order details, the next step is to send this data to Microsoft Power BI. In your Pabbly Connect workflow, add a new action step and select Microsoft Power BI as the application. Choose the action event ‘Add Rows in a Specific Dataset in Group’ to send the captured order details.

Connect your Microsoft Power BI account to Pabbly Connect by allowing necessary permissions. You will then select the group ID and dataset ID where you want to send the order details. Ensure you create a dataset in Power BI that matches the order details you want to track.

• Select the correct group ID from your Power BI workspace.
• Choose the dataset ID where order details will be sent.
• Map the captured order details to the corresponding fields in Power BI.

Once you have mapped the fields, click on ‘Save and Send Test Request’ to verify that the data is sent correctly to Microsoft Power BI. You should see the order details reflected in your Power BI report automatically.

---

5. Conclusion: Automating Order Tracking with Pabbly Connect

In conclusion, integrating BigCommerce with Microsoft Power BI through Pabbly Connect streamlines the process of tracking orders and generating reports. By automating this workflow, you can ensure that your reports are always up-to-date with the latest order information.

Utilizing Pabbly Connect allows you to focus on growing your business while it handles the repetitive tasks of data entry and reporting. Start using Pabbly Connect today to enhance your eCommerce operations and make data-driven decisions with ease.

---

Learn how to integrate Google Sheets with Thinkific using Pabbly Connect for seamless user enrollment in courses. Step-by-step guide included. 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 start integrating Google Sheets with Thinkific, you first need to access Pabbly Connect. If you are a new user, you can sign up for free and receive 100 tasks to get started.

Once you have signed in, navigate to the dashboard of Pabbly Connect. Here, you will find the option to create a new workflow by clicking on the ‘Create Workflow’ button. Enter a name for your workflow, such as ‘Create and Enroll User in Thinkific Course from Google Sheets,’ and click on create.

---

2. Setting Up Google Sheets as Trigger Application

In this step, we will set up Google Sheets as the trigger application using Pabbly Connect. Select Google Sheets from the trigger application options. For the trigger event, choose ‘New or Updated Spreadsheet Row.’ This means that the process will trigger whenever a new row is added or updated in your Google Sheets.

• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

After copying the webhook URL, go to your Google Sheets and navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. Paste the copied URL into the designated field and set your trigger column, which is the final data column in your spreadsheet.

---

3. Capturing Data from Google Sheets

Once you have set up the trigger, the next step is to capture data from Google Sheets using Pabbly Connect. Fill in the necessary details in your spreadsheet, like first name, last name, email, phone, and course. For this example, we will use dummy data.

• Fill in first name, last name, email, phone number, and course in Google Sheets.
• Refresh Pabbly Connect to see the captured data.
• Verify the response received matches your input data.

After filling in the details, refresh your Pabbly Connect dashboard to see the captured response. This confirms that the trigger has successfully captured the data from Google Sheets, which will start the automation process every time a new row is added.

---

4. Defining Conditions for Automation in Pabbly Connect

To ensure that the automation works only for specific courses, you can define conditions using Pabbly Connect. Click on the ‘Add Action Step’ and select ‘Filter by Pabbly’ to set your conditions. Here, you will define that the automation should only proceed if the course name matches the specific course.

Add a filter for course name. Set the condition to check if the course name equals ‘PHP Course for Beginners’. Save and test the filter condition.

Once the conditions are set, save the filter and test it to ensure that it returns the expected results. If the condition is true, the automation will proceed; otherwise, it will stop.

---

5. Enrolling Users in Thinkific via Pabbly Connect

The final step is to enroll users in Thinkific using Pabbly Connect. If the user already exists, you will use the ‘Enroll User’ action in Thinkific. If the user does not exist, you will first create the user and then enroll them.

Select Thinkific as the action application. Choose ‘Enroll User’ as the action event. Map the User ID and course details from the previous steps.

After setting up the enrollment action, test it to verify that the user is successfully enrolled in the specified course. This completes the integration process, allowing seamless enrollment of users from Google Sheets to Thinkific using Pabbly Connect.

---

Conclusion

In this tutorial, we covered how to integrate Google Sheets with Thinkific using Pabbly Connect. This integration enables automatic user enrollment in specified courses, streamlining the process significantly. By following these steps, you can enhance your workflow and improve efficiency in managing course enrollments.

Learn to create Wave transactions automatically for WooCommerce orders using Pabbly Connect. This detailed tutorial walks you through the integration step-by-step. 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. Accessing Pabbly Connect for WooCommerce Integration

To create a Wave transaction for WooCommerce orders, you first need to access Pabbly Connect. Start by visiting the Pabbly Connect website and either sign in or sign up for a free account.

If you are a new user, click on the ‘Sign Up for Free’ button to create your account. After signing up, you will receive 100 free tasks to explore the features of Pabbly Connect. Existing users can directly sign in to access their dashboard.

---

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, you need to create a new workflow. Click on the ‘Create Workflow’ button in the top right corner of the dashboard.

A dialog box will appear, prompting you to name your workflow. Name it ‘Create Wave Transaction for WooCommerce Order’ and click ‘Create’. This will open two windows: one for the trigger and another for the action.

• Select WooCommerce as the trigger application.
• Choose ‘New Order Created’ as the trigger event.
• Copy the provided webhook URL for WooCommerce.

After setting up the trigger, you are ready to connect WooCommerce with Pabbly Connect by following the next steps.

---

3. Connecting WooCommerce with Pabbly Connect

To connect WooCommerce to Pabbly Connect, log into your WordPress account and navigate to WooCommerce settings. Under WooCommerce, select ‘Settings’ and then go to the ‘Advanced’ tab.

Within the Advanced options, select ‘Webhooks’ and click on ‘Add Webhook’. Enter a name like ‘Wave’ and set the status to Active. Choose ‘Order Created’ as the topic and paste the webhook URL you copied earlier. Finally, click on ‘Save Webhook’ to complete the connection.

---

4. Testing the WooCommerce and Pabbly Connect Integration

After saving the webhook, you need to test the integration. Click on ‘Recapture Webhook Response’ in Pabbly Connect. This will allow you to place a test order in your WooCommerce store.

Go to your WooCommerce products, select a product, and add it to the cart. Proceed to checkout and enter the required customer details. Once the order is placed, return to Pabbly Connect, where you should see the order details captured.

• Confirm that the order details include customer information.
• Make sure the response shows the correct product details.

This confirms that your WooCommerce store is successfully integrated with Pabbly Connect.

---

5. Creating a Wave Transaction for the Order

Now, you will create a transaction in Wave for the WooCommerce order. To do this, select Wave as the action application in Pabbly Connect and choose ‘Create Transaction with Line Items’ as the action event.

Connect your Wave account and fill in the required details. Map the customer ID, order key, transaction amount, and other necessary fields. Ensure that you use the mapping feature to dynamically insert customer data for each new order.

Finally, click on ‘Save and Send Test Request’. If successful, you will receive a confirmation response along with the transaction ID from Wave.

---

Conclusion

In this tutorial, we explored how to create Wave transactions for WooCommerce orders using Pabbly Connect. By following the steps outlined, you can automate your order processing seamlessly, ensuring that every new WooCommerce order generates a corresponding transaction in Wave. This integration streamlines your workflow and enhances efficiency.

Learn how to automate user enrollment in Zenler courses from Google Sheets using Pabbly Connect in this step-by-step tutorial. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Zenler, you first need to access Pabbly Connect. If you are a new user, click on the ‘Sign Up Free’ button to create an account and receive 100 free tasks. Existing users can simply log in to their account.

After signing in, navigate to the Pabbly Connect dashboard. Here, you can view existing workflows or create a new one by clicking on the ‘Create Workflow’ button on the right side. Name your workflow, for example, ‘Enroll User in Zenler Course from Google Sheets,’ and click on ‘Create’ to proceed.

---

2. Setting Up the Trigger Application in Pabbly Connect

In this step, you will set up Google Sheets as the trigger application in Pabbly Connect. This is essential for automating the enrollment process. In the trigger setup, search for ‘Google Sheets’ and select it. Choose the trigger event as ‘New or Updated Spreadsheet Row,’ which will activate whenever a new row is added or modified.

• Select Google Sheets as the trigger application.
• Choose the trigger event: New or Updated Spreadsheet Row.
• Copy the webhook URL provided by Pabbly Connect.

Next, go to your Google Sheet where you have the user enrollment details. Under the ‘Extensions’ menu, ensure you have the Pabbly Connect Webhooks extension installed. If not, you can find it in the ‘Get Add-ons’ section. Once installed, go to the Pabbly Connect Webhooks extension and click on ‘Initial Setup.’ Here, paste the copied webhook URL and specify the trigger column, which should be your final data column.

---

3. Capturing Data from Google Sheets

Now that you have set up the trigger in Pabbly Connect, it’s time to capture data from Google Sheets. After refreshing the sheet, click on ‘Send on Event’ in the Pabbly Connect Webhooks extension. This action allows Pabbly Connect to listen for new entries in your Google Sheet.

Fill in a new row with dummy data, including the first name, last name, email, phone number, and the course name. Once you add this data, Pabbly Connect will receive the webhook response, confirming that the details have been captured successfully. You will see the data reflected in the Pabbly Connect interface, including the spreadsheet name and ID.

• Add a new row to your Google Sheet with user details.
• Click on ‘Send on Event’ to trigger data capture.
• Verify that the data appears correctly in Pabbly Connect.

This step ensures that every new entry in Google Sheets triggers the automation in Pabbly Connect, allowing for real-time data processing.

---

4. Filtering Data for Specific Course Enrollment

To ensure that only users who have opted for the specific course enroll in Zenler, you will need to set up a filter in Pabbly Connect. Add an action step and select the filter option. Here, define the condition that the course name must equal ‘Core PHP Programming’ for the automation to continue.

In the filter setup, select the course name from the captured data and set the filter type to ‘Equal To.’ If the condition is met, the workflow will proceed to the next step; otherwise, it will stop. Click on ‘Save and Send Test Request’ to verify the filter’s functionality, ensuring that it only allows the specified course to proceed.

---

5. Enrolling Users in Zenler Using Pabbly Connect

Now that you have filtered the data, it’s time to enroll users in Zenler through Pabbly Connect. Search for Zenler in the action application section and select the action event as ‘Enroll User to a Course.’ You will need to connect your Zenler account with Pabbly Connect by providing your API key and school name.

After successfully connecting, select the course ID and course plan ID for the enrollment. Map the user’s email, first name, and last name from the captured data to ensure that the correct details are sent to Zenler. Finally, click on ‘Save and Send Test Request’ to complete the enrollment process. You will receive a success message confirming that the user has been enrolled in the specified course.

---

Conclusion

This tutorial demonstrated how to automate user enrollment in Zenler courses directly from Google Sheets using Pabbly Connect. By following these steps, you can streamline your workflow and ensure that user data is processed efficiently and accurately.

Learn how to integrate Pabbly, Simply, Automation, URL, Team, and Gmail using Pabbly Connect in this detailed 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 Integration

To begin the integration process using Pabbly Connect, you first need to access the platform. Open your browser and search for the Pabbly Connect website. Once on the landing page, you will see options to either sign in or sign up for free.

If you are a new user, click on the ‘Sign Up for Free’ button to create your account. This process only takes about two minutes, and you will receive 100 free tasks to explore Pabbly Connect. Existing users can simply click on ‘Sign In’ to access their dashboard.

---

2. Creating a Workflow in Pabbly Connect

After signing in to Pabbly Connect, you will be directed to your dashboard. To create a new workflow, click on the ‘Create Workflow’ option located in the top right corner. A dialog box will prompt you to name your workflow.

• Name your workflow, for example, ‘Verify and Send Email for Formstack Submission.’
• Click on ‘Create’ to proceed.

This action opens two windows: one for the trigger and another for the action. In this case, the trigger will be the Formstack application, which captures new form submissions. Select Formstack and choose the trigger event as ‘New Form Submission.’

---

3. Connecting Formstack to Pabbly Connect

To connect Formstack with Pabbly Connect, click on ‘Connect’ and select ‘Add New Connection.’ You will be prompted to authorize Pabbly Connect to access your Formstack account. Make sure you are logged into your Formstack account to simplify this process.

Once authorized, you will need to select the specific form you wish to use. Navigate to your Formstack account and find the form named ‘Integration.’ Select this form in Pabbly Connect and click on ‘Save and Send Test Request.’ This will prepare Pabbly Connect to capture the responses from the Formstack form.

---

4. Verifying Email Using Pabbly Connect

After capturing the form submission response, the next step in your workflow using Pabbly Connect is to verify the email address. For this, choose ‘Email List Verify’ as your action application and select ‘Single Email Verify’ as the action event.

• Click on ‘Connect’ and select ‘Add New Connection.’
• You will need to enter your API key from the Email List Verify account.

After entering the API key, map the email address from the Formstack response to ensure that Pabbly Connect dynamically uses the email submitted in the form. Click on ‘Save and Send Test Request’ to verify the email, and ensure that the response indicates that the email is valid.

---

5. Sending Email via Gmail Using Pabbly Connect

Once the email is verified, the final step is to send an email to the person who submitted the form. In Pabbly Connect, add another action and select ‘Gmail’ as the application. Choose ‘Send Email’ as the action event.

Click on ‘Connect’ and then ‘Add New Connection’ to link your Gmail account. Authorize Pabbly Connect to access your Gmail account by clicking ‘Allow.’ After successfully connecting, you will need to fill in the required fields such as recipient email, sender name, subject, and email body.

Map the recipient’s email address from the Formstack response, and customize the email content to include a greeting and the submitted details. Finally, click on ‘Save and Send Test Request’ to send the email. You should receive a confirmation that the email has been sent successfully.

---

Conclusion

In this tutorial, we demonstrated how to integrate Pabbly, Simply, Automation, URL, Team, and Gmail using Pabbly Connect. By following these steps, you can automate the process of verifying emails and sending notifications effortlessly. Explore the capabilities of Pabbly Connect for more integrations.

Learn how to integrate Miller Lite with Zendler using Pabbly Connect for seamless subscriber management. Follow our step-by-step tutorial for automated workflows. 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 Integration

To integrate Miller Lite with Zendler, you first need to access Pabbly Connect. Start by logging into your Pabbly Connect account or create a free account if you haven’t already.

Once logged in, navigate to the dashboard. Click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For this integration, name it something like ‘Create Miller Lite Subscribers from Zendler Leads Automatically’. After naming, click on the ‘Create’ button to proceed.

---

2. Connecting Zendler to Pabbly Connect

In this step, you will set up the trigger in Pabbly Connect to capture new leads from Zendler. Select Zendler as your trigger application and choose the trigger event as ‘New Lead’. This event will initiate the workflow whenever a new lead is generated.

• Select ‘New Lead’ as the trigger event.
• Click on ‘Connect’ to establish a connection with Zendler.
• Enter your API key and account name to connect.

After entering the required details, click on ‘Save’. Pabbly Connect will now be linked to your Zendler account, allowing it to capture lead details automatically. You can test this connection by creating a new lead in Zendler and checking if the data appears in Pabbly Connect.

---

3. Adding Leads to Miller Lite via Pabbly Connect

Now that Zendler is connected to Pabbly Connect, the next step is to add the captured lead data to Miller Lite. For this, select Miller Lite as your action application and choose the action event as ‘Create or Update Subscriber’. This will allow you to automatically add new leads as subscribers.

To connect Miller Lite, click on the ‘Connect’ button and follow the prompts to enter your API token. If you’re already logged into your Miller Lite account, you can generate a new token by clicking on the relevant button in the connection setup.

• Generate a new token in Miller Lite.
• Copy the token and paste it into Pabbly Connect.
• Save the connection.

Once connected, you can map the lead details captured from Zendler to create a new subscriber in Miller Lite. This ensures that every new lead is automatically added to your email marketing list.

---

4. Testing the Integration Workflow

With the connections established, it’s time to test your workflow in Pabbly Connect. Create a new lead in your Zendler account using dummy details. After submission, Pabbly Connect will automatically fetch the lead information.

Check the response in Pabbly Connect to ensure that the lead details have been captured correctly. If successful, you will see the lead’s first name, last name, and email address displayed in the response section. This confirms that the integration is functioning as intended.

Next, verify that the lead has been added to your Miller Lite account. Navigate to the subscribers section in Miller Lite and check for the newly created subscriber. If everything is set up correctly, you should see the lead listed with the correct details.

---

5. Automating Your Lead Management Process

Now that you have successfully integrated Zendler and Miller Lite using Pabbly Connect, your lead management process is automated. This means that every time a new lead is generated in Zendler, it will automatically be added as a subscriber in Miller Lite without any manual intervention.

This automation not only saves time but also ensures that your email marketing lists are always up to date. You can relax knowing that Pabbly Connect will handle the integration seamlessly in the background.

Remember to monitor your Pabbly Connect dashboard for any updates or errors in the workflow. This will help you maintain an efficient lead management system and quickly address any issues that may arise.

---

Conclusion

By using Pabbly Connect, you can effortlessly integrate Miller Lite with Zendler to automate lead management. This tutorial provides a clear step-by-step guide to setting up your workflow, ensuring that your subscribers are always updated.

Learn how to integrate Pabbly Connect with Google Sheets to automate date and time entries in your workflows. Step-by-step guide included! Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

---

1. Introduction to Pabbly Connect and Its Functionality

Pabbly Connect is an essential tool for automating workflows by integrating various applications seamlessly. In this tutorial, we will explore how to use Pabbly Connect to add the current date and time into your automation workflow.

This is particularly useful when you capture responses that do not provide date and time information. By utilizing specific functions within Pabbly Connect, you can effortlessly insert the current date and time into your Google Sheets.

---

2. Setting Up the Webhook in Pabbly Connect

To start, access Pabbly Connect and create a new workflow. The first step is to set up a webhook to capture the response data. This webhook will allow you to collect information such as first name, last name, email address, and mobile number.

After creating the webhook, you will receive a unique URL. This URL should be used in the application that sends the data. Here are the steps to set up the webhook:

• Create a new workflow in Pabbly Connect.
• Select the webhook option to capture the response.
• Copy the provided webhook URL for use in your application.

Once the webhook is set up, you can test it by sending a sample response to ensure that Pabbly Connect captures the data correctly.

---

3. Integrating Google Sheets with Pabbly Connect

After successfully capturing the response via the webhook, the next step is to integrate Google Sheets using Pabbly Connect. This integration allows you to add the captured data along with the current date and time into a designated Google Sheet.

Follow these steps to connect Google Sheets:

• Select Google Sheets as the application in Pabbly Connect.
• Choose the action event as ‘Add New Row’.
• Connect your Google account by selecting ‘Sign in with Google’.
• Authorize Pabbly Connect to access your Google Sheets.

Once connected, you can select the specific spreadsheet and map the fields to ensure that the data from the webhook is correctly inserted into the relevant columns.

---

4. Adding Date and Time Functions in Pabbly Connect

In this step, we will utilize specific functions within Pabbly Connect to add the current date and time in various formats. This is crucial for maintaining accurate records in your Google Sheets.

Here are the functions you can use:

UTC Time Zone: Outputs the current date and time in UTC format. Local Time Zone: Displays the current time in your local time zone. Timestamp Format: Provides the current time in timestamp format. Local Timestamp: Outputs the current time in local timestamp format.

These functions should be copied and pasted into the respective fields in your Google Sheets integration to ensure that the date and time are recorded correctly alongside the other captured data.

---

5. Testing the Integration in Pabbly Connect

After setting up the functions, the final step is to test the integration to ensure that all data, including the current date and time, is correctly inserted into your Google Sheet. You can do this by clicking on ‘Save and Send Test Request’ in Pabbly Connect.

If everything is set up correctly, you should see the response in your Google Sheet reflecting the first name, last name, email address, contact number, and the various date and time formats. This confirms that your automation workflow is functioning as intended.

In summary, using Pabbly Connect to automate the addition of date and time in your workflows enhances efficiency and accuracy in data management.

---

Conclusion

In this tutorial, we explored how to use Pabbly Connect to integrate Google Sheets for automating date and time entries. By following the precise steps, you can streamline your workflows and enhance productivity.

Learn how to update Google Sheets and send email notifications for updated entries in Cognito Forms using Pabbly Connect. Step-by-step tutorial included. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

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 visiting the Pabbly website and selecting the option to sign in or sign up for free. If you are a new user, creating an account is quick and grants you 100 free tasks to explore the platform.

Once signed in, navigate to the ‘All Apps’ section where you can find various Pabbly products. Click on Pabbly Connect to access the dashboard, where you can create and manage your automation workflows.

---

2. Creating a Workflow in Pabbly Connect

To create a new workflow in Pabbly Connect, click on the ‘Create Workflow’ button located in the upper right corner of the dashboard. You will be prompted to name your workflow; for this tutorial, name it something like ‘Cognito Forms to Google Sheets to Gmail’. After naming, click on ‘Create’.

• Select Cognito Forms as the trigger application.
• Choose the trigger event as ‘Update Entry’.
• Copy the provided webhook URL for use in Cognito Forms.

After setting up the trigger, you will see two windows: one for the trigger and another for actions. This setup allows you to automate the entry updates from Cognito Forms to Google Sheets and send notifications via Gmail using Pabbly Connect.

---

3. Configuring Cognito Forms for Updates

Next, head to your Cognito Forms account and select the form you wish to use. Enable the ‘Post JSON data to a website’ option under the form settings. Paste the copied webhook URL from Pabbly Connect into the ‘Update Entry Endpoint’ field and save your changes.

Now, go back to Pabbly Connect, which will show it is waiting for a response. You need to perform a test submission by updating an entry in your Cognito Forms. Make a small change to an entry, such as updating a phone number, and save it.

---

4. Updating Google Sheets with Pabbly Connect

Once the entry is updated in Cognito Forms, return to Pabbly Connect to process the action. First, select Google Sheets as the action application and choose the ‘Lookup Spreadsheet Row’ action event. Connect your Google account to allow Pabbly Connect to access your sheets.

• Select the spreadsheet where your data is stored.
• Set the lookup column to the entry number.
• Map the entry number from Cognito Forms to find the corresponding row.

After configuring the lookup, click on ‘Save and Send Test Request’. This will retrieve the row data from Google Sheets, allowing you to update the necessary fields based on the updated entry.

---

5. Sending Email Notifications via Gmail

Finally, to send an email notification to the user, add another action step in Pabbly Connect by selecting Gmail as the application and choosing ‘Send Email’ as the action event. Connect your Gmail account and set up the email details, including the recipient’s email, subject, and body content.

Make sure to map the user’s details from the previous steps, such as their name and updated contact information, into the email body. After entering all the required fields, click on ‘Save and Send Test Request’. You should receive a confirmation that the email has been sent successfully.

---

Conclusion

This tutorial has demonstrated how to use Pabbly Connect to automate the process of updating Google Sheets and sending email notifications when entries are updated in Cognito Forms. By following these steps, you can streamline your workflow and enhance communication with users efficiently.