Skip to main content
Question

Scheduling issues with Zapier and Google Sheets for invoice reminders

  • May 29, 2025
  • 5 replies
  • 37 views

Bonjour 

 

J ai un souci avec mon zap pour effectuer un schedule sur des relances de factures par rapport à des dates . Lorsque je connecte avec ma google sheets , j ai un message de false lors du test

Pourriez vous m’aider ? 

 

Translation:

Hello I'm having trouble scheduling invoice reminders based on specific dates using my Zap. When I connect to my Google Sheets, I get a false message during the test. Could you help me?

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.

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

5 replies

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6780 replies
  • May 30, 2025

Hi there ​@JULIE81TARN,

Welcome to the Community! 🎉

Before we dig deeper into this, could you please send a screenshot of the DATE column in your Google Sheets? Additionally, could you please try typing 29/5/2025 on the “Lookup value” field and try testing the Zap?

I'll be keeping an eye out for your response!


  • Author
  • New
  • 3 replies
  • May 30, 2025

Bonjour ​@ken.a 

 

je vous envoie les screenshot mais malheureusement cela ne fonctionne toujours pas 

Merci d’avance pour votre aide

 

Moderator edit to include Google Translation of original message:
Hello ​@ken.a 

I'm sending you the screenshots, but unfortunately, it still doesn't work.

Thank you in advance for your help.

 

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.


  • Author
  • New
  • 3 replies
  • May 30, 2025

voilà d’autre screenshots

🙏
 

Moderator edit to include Google Translation of original message:

Here are some more screenshots

🙏

 

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.


  • Author
  • New
  • 3 replies
  • May 30, 2025

Meme avec formatter je n y arrive pas 

Help

Moderator edit to include Google Translation of original message:
I can't do it even with formatting.

Help

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9736 replies
  • June 16, 2025

Hi ​@JULIE81TARN 👋

So sorry you didn’t get a reply here sooner. Looking at your initial screenshot it seems like the slash (/) in between the month and year value is missing:

0c0dba494e00b8821225307a4c49dca4.png
 

It looks like you’ve correctly got a / in between the Date Day and Date Month fields though.

Can you try adding a / in between the Date Month field and Date Year fields and let us know if that fixes it?