Triggering Data from Google Sheet

Hi Golden YN,

Thank you for reaching out to Pabbly Support.

We checked your workflow Birthday Wishes on WhatsApp and its execution logs:

Why This Happens

1. Scheduled Execution Time (23:30 UTC = 05:00 AM IST):

   • Your workflow is scheduled to run daily at 23:30 UTC (which equals 05:00 AM IST).

2. UTC Output in Current Date Step:

   • Step 2 (DateTime Formatter – Current Date) outputs the current date in UTC format.

   • When the workflow ran on Aug 06 at 05:00 AM IST, the UTC time was Aug 05 at 23:30 UTC, so it generated 05/08/2026 instead of today's date.

How to Fix It (Step-by-Step)

To convert this UTC date into your local date (Asia/Kolkata) before looking up rows in Google Sheets, follow these steps:

1. Add a New Action Step:

   • Click the + icon immediately after your Current Date step (Step 2) to add a new action step.

2. Select DateTime Formatter:

   • App: Select DateTime Formatter (Pabbly).

   • Action Event: Select Format Date with Timezone.

3. Configure the Fields:

   • Date: Map the result output (currentDate) from the previous Current Date step.

   • From Format: Select DD/MM/YYYY.

   • To Format: Select DD/MM/YYYY.

   • From Timezone: Select UTC.

   • To Timezone: Select Asia/Kolkata (or your preferred local timezone).

4. Save & Test:

   • Click Save & Send Test Request to generate the converted local date.

5. Update Next Steps (Re-mapping):

   • Go to your Google Sheets (Lookup Spreadsheet Rows V2) step and re-map the date field to use the converted result output from this new DateTime Formatter step.

Once saved, the workflow will always convert the execution time to the correct local date (e.g., 06/08/2026) before searching your spreadsheet.

Please let us know if you need any assistance setting this up!