Update a cell in Google Sheet not working


I try to set up a scenario where I have a google sheet, and when a new row is added, it’s automatically sending and e-mail. When e-mail is sent, column “status” of this row is updated to “sent” (envoyé) and a the time where is was sent is added to the column “date”.

E-mail is sent correctly, but I can’t make it work to update the cell !
And I have no error message at all…
Does someone has an idea ?


Welcome to the Make community!

1. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

2. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!


Hi @Thezea

Your requirement is to update the Statut column, Please check the Cell Id instead of {{1.Status}}
eg: C{{1.Row Number}}

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel


It worked, thank you !