Google Script – get data from Gmail into Sheet

I have been looking around here on SO and on Google, but I cannot find anything that is working. So when I am running my code below, I am getting the result on the image. I want to extract data from the newest/most recent thread in mails that have a specific label. However, in my Gmail, I only have the 3 mails under “Action”-label that I have highlighted in bold. The other mails have been deleted, hence, they are in trash, but do still have the “Action” label. I want to only show the mails that I have “Action”-label on

How can I get color from CalendarEvent object on google apps script?

I want to get the color(red) below the picture. enter image description here I use next code, but I don’t know next step. run main function. var mainCalendarName = ‘main’; function main() { var …

Checking if an email is valid in Google Apps Script

I’m using the built-in api for scripting against Google Spreadsheets to send some booking confirmations, and currently my script breaks if someone has filled in an invalid email. I’d like it to just …