• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

  • Please note that the team will not be available on April 17th, 2024, due to a public holiday in India.

    During this period, support assistance may experience some delays.

Google Sheets (1 Minute Trigger) Send New rows in every 1 minute.

Status
Not open for further replies.



In this tutorial, we will see how can you set up Google sheets trigger "New or Updated Spreadsheet Row" in Google Sheet so that you can capture data every minute.

Please note: We also offer a Pabbly Connect Webhooks addon for Google Sheets.

The current limitations of the Google Sheets trigger addon are as follows:
  1. If a new row is added inside Google Sheets from any external platform, it is used to trigger every 1 hour.
  2. If there are any formula-based columns that are set as trigger columns. It does not trigger and send the row.
This script is a supplement for our Google Sheets add-on 'Pabbly Connect Webhooks'. It can be used alone without the need of using our Pabbly Connect Webhooks addon. Using the script below removes the limitations mentioned above.

To make the system function, the script shared in Step 3 has to be saved as an Apps Script project within the spreadsheet where the Google Sheets data resides. There is no communication between this script and the Pabbly Connect Webhooks add-on or any other add-on. Hence it won't interfere with any installed add-on. Also, note the script will work on any single Sheet of your Spreadsheet.

Below is the detailed process on how to set this trigger using Apps Script:
  1. Open the spreadsheet from where you wish to send data. Make sure your sheet has a header column and at least a row of data in it.

    Screenshot 2023-03-29 at 4.16.32 PM.png



  2. Open the Apps Script editor through the Sheets menu: Extensions > Apps Script.

    Screenshot 2023-03-29 at 4.20.34 PM.png


  3. Remove any existing Apps Script codes (visible in Code.gs) file. Paste the entire App Script code from the link below. Save the project and close the Apps Script page. You can rename the project if you like or you can ignore the name.

    Click the link to access the app scripts code. https://forum.pabbly.com/threads/google-sheets-1-minute-trigger.12927/ .

    Screenshot 2023-03-29 at 4.25.40 PM.png

  4. Reload the spreadsheet. A new menu shall appear.

    Screenshot 2023-03-29 at 4.29.46 PM.png


  5. Find the Sheets menu 'Pabbly Webhooks'. Click 'Pabbly Webhooks' > 'Send rows every minute'.

    Screenshot 2023-03-29 at 4.31.16 PM.png


  6. Authorize this script when prompted.

    Screenshot 2023-03-28 at 12.56.10 PM.png


  7. Once the authorization is complete, again navigate to 'Pabbly Webhooks' > 'Send rows every minute'.

    Screenshot 2023-03-29 at 4.31.16 PM.png


  8. To set up the Pabbly Connect webhook, a dialog box will appear where you need to fill out an input field with the webhook URL. After filling in the URL, select "Yes" to confirm. Alternatively, you can add the webhook URL and the column name (trigger column) separated by a comma too.

    It is important to note that if you only add the webhook URL, the trigger column will be set as the last column in the entire data range of the sheet. This means that any row data will trigger when it is filled up to the last column.
    For example, if data is filled up to Column C in any particular row, and that is the last column of the sheet that has data in it, other rows will trigger when the data is filled in the rows till the C column.

    Screenshot 2023-03-29 at 4.32.32 PM.png

    Screenshot 2023-03-29 at 4.33.13 PM.png


  9. Now start capturing the data by the Pabbly Connect Trigger.

    Screenshot 2023-03-28 at 9.41.45 PM.png


    The data will be captured in a few seconds. As soon as the 1-minute trigger executes. Further, any new record in the Google Sheets will trigger and send the new row data to the Pabbly Connect trigger.

    1680154046235.png

    The trigger process is completed here.

  10. Once the data is captured. You can send the data captured in Google Sheets Trigger to any place you want. For example, you can Add a new action to save the data captured by the webhook in your CRM system or any other place that you want.

    1680154215412.png


    Note: The action used here is just for reference, you can apply any other action that you need.
 
Last edited by a moderator:
Status
Not open for further replies.
Top