I'm just your average Jane, not a coder, trying to set up Google Data Studio to analyze my gmail usage in GSheets, but since the instructions (bymarketers.co/analyse-you…) went up, Google apparently changed from a "script editor" under Tools to Apps Script, and I suspect there is now something also wrong with the code I was instructed to use. I put in the following as suggested, and get the message "Syntax error: SyntaxError: Invalid or unexpected token line: 1 file: Code.gs. I am unable to save or run the code. function pullEmailData() { var ss = SpreadsheetApp.getActiveSheet(); var label = GmailApp.getUserLabelByName(“Email Analysis”); var threads = label.getThreads(); for (var i = 0; i < threads.length; i++) {var messages = threads[i].getMessages(); for (var j = 0; j < messages.length; j++) {var to = messages[j].getTo(); var from = messages[j].getFrom(); var sub = messages[j].getSubject(); var date = messages[j].getDate(); var important = messages[j].isInPriorityInbox(); var starred = messages[j].isStarred(); ss.appendRow([to, from, sub, date, important, starred]);} threads[i].removeLabel(label);}} enter image description here Any thoughts what I should fix to make this work? I expected to be able to run the code but when I try to save it I get the Syntax error and the run icon remains greyed out. I don't know enough to know where else to look for solutions. I typed the error message into google and found this group and looked at some similar questions but didn't find an answer that helped/made sense to me. I made sure there wasn't an extra space in front of the function but that wasn't the problem.
