How to Use Code by Pabbly Action Inside Pabbly Connect – Pabbly Tutorial

Learn how to use Code by Pabbly Action in Pabbly Connect for automating Google Sheets updates with JavaScript. Step-by-step guide included. 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. Accessing Pabbly Connect for Automation

To begin using Pabbly Connect for automating tasks, first, log in to your Pabbly Connect account. This platform acts as the central hub for integrating various applications, including Google Sheets, Facebook, and YouTube.

Once logged in, you can create a new workflow. This setup allows you to automate processes effectively. For this tutorial, we will focus on checking and updating data in Google Sheets using JavaScript.

2. Connecting Google Sheets with Pabbly Connect

In this section, we will connect Google Sheets to Pabbly Connect. Start by selecting Google Sheets as your trigger application. The trigger event will be set to ‘New or Updated Spreadsheet Row’. This event initiates the workflow when any row in the spreadsheet is modified.

• Choose Google Sheets as the trigger application.
• Set the trigger event to ‘New or Updated Spreadsheet Row’.
• Connect your Google account and select the desired spreadsheet.

After making the connection, you will see a response section where data from the spreadsheet will be captured. This will include details such as the row index and the status of the stock in your inventory.

3. Using Code by Pabbly to Run JavaScript

Next, we will utilize the Pabbly Connect feature called Code by Pabbly. This allows you to run JavaScript code within your automation workflow. In the action step, select ‘Run JavaScript’ as the action event.

Here, you will write a simple JavaScript code snippet. This code will check if the stock status in the specified column is empty. If it is empty, the code will return ‘yes’. Otherwise, it will retain the existing value. The code will look something like this:

• Use an if-else statement to check the stock status.
• Map the stock status from the previous step into your code.
• Test the code to ensure it returns the correct output.

Once the code is written, click on ‘Save and Test Request’. If the stock status is empty, the output should return ‘yes’. This confirms that your JavaScript code is functioning correctly.

4. Updating Google Sheets with Pabbly Connect

After running the JavaScript code, the next step is to update the Google Sheets with the new value. Go back to Pabbly Connect and add another action step. Select Google Sheets again, and this time choose the action event ‘Update Cell Value’.

In this step, you will need to connect to Google Sheets again. Choose the same spreadsheet and specify the range where you want to update the value. For instance, if the stock status is in column C, you will map the row index from the previous step to the corresponding cell.

Select the spreadsheet name and sheet name. Map the cell range where the update will occur. Map the value you want to insert, which is ‘yes’ in this case.

After mapping all necessary fields, click on ‘Save and Send Test Request’. This action will fill the empty cell with ‘yes’, completing the automation process.

5. Finalizing Your Automation with Pabbly Connect

Once you have set up the entire workflow in Pabbly Connect, it’s essential to review your automation. Ensure that all connections are functioning correctly and that the JavaScript code executes as intended.

Remember, the power of Pabbly Connect lies in its ability to integrate multiple applications seamlessly. You can extend this workflow by adding more actions or integrating additional applications like Facebook and YouTube for further automation.

In conclusion, using the Code by Pabbly feature within Pabbly Connect allows you to execute JavaScript code, automate data checks, and update Google Sheets efficiently. This integration can save you time and streamline your workflow.

Conclusion

In this tutorial, we explored how to use Code by Pabbly Action inside Pabbly Connect to automate Google Sheets updates using JavaScript. This powerful integration enhances productivity by automating data management tasks effectively.