• 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 17th June 2024, due to a public holiday.

    During this period, support assistance may experience some delays.

Add or update row in Google Sheets

Lars

Member
Hi, can't find how to add a step in Connect that will either add a new row if unique key isn't already in an existing row, or update an existing row if key is found. Doable, right?

And I'm retrieving the data from another Google sheet (not that it should matter, I suppose).

Thanks,
Lars.
 
P

PabblyMember4

Guest
Hey @Lars

You can use the Lookup function in the Google sheet to search the content in it. Then you can use the Router and add the conditions in Router 1 if the unique Key exists then update the row.

In Router 2 if the unique key does not exist then you can add a new row in the Google sheet.

Please let me know if you have any questions or comments.
 

Lars

Member
Hej, thanks, I suspected that that would be the answer - and had hoped for a simplified similar to for example Mailerlite integration, where the actions is add/update depending on whether the subscriber exists or not.
 

Lars

Member
Hey @Lars

You can use the Lookup function in the Google sheet to search the content in it. Then you can use the Router and add the conditions in Router 1 if the unique Key exists then update the row.

In Router 2 if the unique key does not exist then you can add a new row in the Google sheet.

Please let me know if you have any questions or comments.
Strange - I'm now populating the router and attempting to add new row in sheet, but the selection of columns from the first step doesn't display all the columns. What I'm doing is trigger action when row is added or updated in sheet 1, lookup key value from that row in sheet 2, if key is matched then update else add new row copying data from sheet 1.
 
P

PabblyMember4

Guest
Hey @Lars

Could you please add the required Google Sheets and let me know to check the details? As of now, you haven't added the details to check it further. Further, you have added the router's if condition wrongly, kindly manually type the value in the Value column.

1670669405235.png
 

Lars

Member
Hey @Lars

Could you please add the required Google Sheets and let me know to check the details? As of now, you haven't added the details to check it further. Further, you have added the router's if condition wrongly, kindly manually type the value in the Value column.

View attachment 18963
I'm fiddling some more with this now, will get back to you if needed.

But I don't understand what you're saynig about adding a manula value in the Value column - the whole point here is to check if a preceding lookup step in a Google sheet find the value in the URL filekd, and if not, then create it, so I really don't see how to enter a static value and achieve this?
 
P

PabblyMember4

Guest
Hey @Lars

Usually, we suggest all the users keep the value field as a manual field. However, in your case, you are filtering the URL values so you can continue with adding URL in the filter condition.
 

Lars

Member
Strangely, although setup, test send and submit all returned success messages, this automation isn't triggering. I've emailed your support about this, no reply yet.
 
P

PabblyMember4

Guest
Hey @Lars

We will reply back on the ticket and let you know about it. Kindly do a follow up on the ticket so that we will prioritize it.
 

Lars

Member
Hi, starting to narrow this down a bit. It appears that the trigger does appear to fire as intended, but the router at the end of the workflow returns false for both conditions.

What I’m trying to achieve is that once triggered, perform a lookup in another sheet for a unique value in the new/updated row in the current sheet. The lookup returns either a row number or 0, if I’ve understood correctly, and I’ve set the router up to create a new row if 0 is the returned value, otherwise update the row at the returned row number. But it isn’t working with the way I’ve set it up and so I really need som clever input here on what I’ve done wrong.
 
P

PabblyMember4

Guest
Hey @Lars

Could you please once check the router condition again as you are checking it Rowindex:97=0 every time, because of which you are not getting the data in the Google sheet?

Kindly share the google sheet on [email protected] and also mention this thread id.
 

Lars

Member
Hey @Lars

Could you please once check the router condition again as you are checking it Rowindex:97=0 every time, because of which you are not getting the data in the Google sheet?

Kindly share the google sheet on [email protected] and also mention this thread id.
I shared the sheet as instructed last Sunday, and of course I'm not checking literals! Before the router comes a Google sheet lookup which return either a row number of key already exists, or zero if it doesn't. QUESTION: Does it return zero or som other value of the row doesn't exist? Can't find documentation or video regarding this.

And yes, I've followed up twice now, and still no reply. As a paying customer, I'm currently less than happy.
 
P

PabblyMember4

Guest
Hey @Lars

We have made some changes in the Router>> Filter condition and check if the value you are searching for via the Lookup function exists in the Google Sheet then update the records and if the value does not exist then it will create a new record in the Google sheet.

1671186981551.png



1671187066970.png


Kindly check the scenario and let me know if it helps.
Thanks
Kunal
 
Top