• 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

Search results

  1. searchdusoleil

    Date time formatter Google sheets workflow

    Hi there, thanks for coming back to me. It is running now yes - I started the workflow from scratch. I think I might have done things in the wrong order initially, and so it wasn't picking up the "send on event" settings on the add-on. Thanks again.
  2. searchdusoleil

    Date time formatter Google sheets workflow

    I am pasting in sheet1, want pabbly to run a date format and then send the result into sheet2. Could you have a look at my workflow?
  3. searchdusoleil

    Date time formatter Google sheets workflow

    It is set up correctly as far as I can see: The test send works, but not when new rows are added...?
  4. searchdusoleil

    Date time formatter Google sheets workflow

    I have a bunch of date/time entries I need to convert - have set up a workflow that is > new row on sheet1 > date/time formatter > new format on new row on sheet2 The test send works, and is saved, however it isn't running when I add new rows on sheet1 - is there a delay? How often does the add...
  5. searchdusoleil

    Date/Time Formatter missing format

    Thanks - it was the "map" toggle on the right that allows the format to be edited. I didn't see that anywhere in the tutorial.
  6. searchdusoleil

    Date/Time Formatter missing format

    I need to convert this - 2021-09-28T08:52:17.436Z - which is pulled in from Google My Business, to this - 28/09/2021 08:52:17 - before importing into Google sheets. This format is missing from the Date/Time Formatter - it only has "DD/MM/YYYY hh:mm:ss A" and I do not want the AM/PM adding, as...
  7. searchdusoleil

    Import Google sheet data from one sheet to another

    For anyone else looking at how to do this - I did it outside of pabbly with QUERY and "IMPORTRANGE" as described here: https://stackoverflow.com/questions/31657470/combining-multiple-spreadsheets-in-one-using-importrange
  8. searchdusoleil

    Import Google sheet data from one sheet to another

    Thanks for the suggestion - I managed to get the last cell populated in the first sheet by using an array in the header "=ArrayFormula(IF(ROW(B:B)=1,"sheetname",IF(ISBLANK(B:B),"","sheetname")))" This works fine for me - but; - I am having trouble with the copying from one sheet to a...
  9. searchdusoleil

    Import Google sheet data from one sheet to another

    I wonder if someone could help - I have 25 workflows that are bringing in Google My Business reviews into there own google sheets. I want to create a workflow that will consolidate all these sheets into one new sheet, which I believe I can do with pabbly. What I also need to do, is at the time...
  10. searchdusoleil

    Google My Business fields NumberRating and StarRating

    Thank you for your help, this now works.
  11. searchdusoleil

    Google My Business fields NumberRating and StarRating

    Any help on this please? Are there any tutorials or videos on updating 2 sources into the same google sheet/row?
  12. searchdusoleil

    Google My Business fields NumberRating and StarRating

    I have tried this by adding a lookup table after the Google My Business trigger step, but can't figure out how to get the lookup values AND the Google My Business values mapped to the google sheet?
  13. searchdusoleil

    Google My Business fields NumberRating and StarRating

    Not converting as such, I used to used Zapier, and it brought both fields in the feed. But yes, I am using Google sheets.
  14. searchdusoleil

    Google My Business fields NumberRating and StarRating

    I wonder if anyone has come across this issue - the information pulled from Google My Business reviews is missing the "NumberRating" field which is in number format ie. "5" as opposed to the StarRating, which is pulled in word format, ie. "FIVE". This causes an issue for me further down my...
Top