Best answer

Google Sheet Lookup keeps failing

  • 5 December 2023
  • 7 replies
  • 24 views

Userlevel 1

Im creating a zap that triggers from the “Schedule by Zapier” at 5am each day.  From there I do a google sheet lookup in col A for the current days date.  The date in the google sheet is formatted as the “Pretty Date”.  Below are screen shots of the lookup fields in zapier.

 

icon

Best answer by Troy Tessalone 5 December 2023, 03:46

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 7
Badge +14

@spinman 

Yes, to convert the date from Step 1 into the date format used in GSheets. (M/D/YYYY)

Userlevel 1

Thanks.  I got it to work.

Userlevel 1

 

Userlevel 7
Badge +14

@spinman 

This is the actual value in the cell.

 

For the Lookup Value, you can add this Zap action: Formatter > Date & Time > Format

 

Userlevel 1

so add a formatter step after the schedule by zapier step?

Userlevel 7
Badge +6

That’s awesome @spinman! Big thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Userlevel 7
Badge +14

Hi @spinman 

Good question.

Make sure each GSheet column has a Header label.

Post screenshots with how your GSheet is configured to give us true context.

NOTE: The GSheet cell display value may be different from the GSheet cell internal value, which can be seen in the formula bar in GSheets.