• 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

Google Sheet Issue

Status
Not open for further replies.

mvabhi

Member
Hi Team,

I am trying to set up a reminder based on the date column (col E) in google sheets, Idea is to set up a reminder when the dates in col E matches the current date.

I am successfully able to connect the sheet but I am unable to fetch the data. Please help

1717167618455.png


1717167510647.png


1717167668642.png


1717167581402.png


1717167769146.png
 

ArshilAhmad

Moderator
Staff member
Hi @mvabhi,

The date in your Google Sheets doesn't begin with a 0; it's 5/31/2024 in your Google Sheets spreadsheet instead of 05/31/2024. The data you map in the 'Lookup Spreadsheet Rows' action step needs to be exactly the same as in your spreadsheet.

We have added a Text Formatter to your workflow, which will convert the date into the same format as in your spreadsheet. This appears to be giving you the correct result.
1717175012026.png
 
Status
Not open for further replies.
Top