Skip to main content

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.

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!


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.


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.


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.


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?