Issues with google ads report: Getting yesterdays spend -> google sheet row

[Jeppe_LN1]

What are you trying to achieve?

I would like to have a scenario with my daily google ads spend each day is transferred to a row in my google sheet.

Steps taken so far

I am using the module “google ads reports”, however i have issues with my the date.
I run a report, and in the dates fields I have this:

start date: {{formatDate(addDays(now; -1); “yyyy-MM-dd”)}}
End date: {{formatDate(addDays(now; -1); “yyyy-MM-dd”)}}

When I run the scenario i get the following error (screenshot attached). Can anyone guide me in the right direction, I can’t figure out why this is the case. Maybe there is a smarter way of solving my problem. Best regards.

Screenshots: scenario setup, module configuration, errors

[samliew]

Welcome to the Make community!

Try without the formatDate function.

{{ addDays(now; -1) }}

^{(copy-paste the above into the field, or type it exactly as shown)}

And make sure that the end date is after the startDate, so you just need the now variable in the field.

Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

— @samliew