Hi guys may I ask what's wrong in line 16. Sorry I still don't really quite understand app script yet



It is invalid syntax and you are missing to pass a value for getDataRange() method


How?(I don't really get it...Sorry)

You are probably missing a plus sign after the exclamation mark:

"!" + sh.getDataRange()

thats how it should be

1 Like

Thank you

Does what you are doing (mixing a query with an appendRow) actually work ?

Idk i'm just copying it :sweat_smile:

Not really sure what you are attempting to do. The output of the query goes nowhere / does nothing, and why, if the email is already in the spreadsheet, do you then post the email's additional data (again?)

Dangerous stuff!!

1 Like

Sorry i'm still new to this and i'm just copying what I watch in youtube