• 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 - Interakt Data Fetching issues

ac24365

Member
I am facing issues with the Google Sheet intergrations.
The Google Sheet data isnt getting fetched. It's an integration to send Birthday Messages
Kindly help resolve it.
 

Attachments

  • Screenshot 2024-01-18 at 10.44.09 PM.png
    Screenshot 2024-01-18 at 10.44.09 PM.png
    257.3 KB · Views: 21
  • Screenshot 2024-01-18 at 7.07.26 PM.png
    Screenshot 2024-01-18 at 7.07.26 PM.png
    18.6 KB · Views: 21

ac24365

Member
Thanks for the info.
Though now I can see the data, it's still not fulfilling my requirement. It's just picking up all birthdays which match 18/01/2023. However the bdays on 18/01 in other years its not collecting. My requirement is that The lookup value needs to pick up the day and month from the date field of the Sheet and ignore the year so that anyone having a bday on 18/01 in any year can be send a message. How to achieve this?
 

ArshilAhmad

Moderator
Staff member
To achieve this, you can create a separate column in your Google Sheets, enter the date and month without the year, and look up that particular column.
 
Top