Write App Script function for Google Sheets
Budget: $10 – $30 USD
I'm looking for an App Script developer to write a simple function that utilises the GmailApp method to send an email to a list of recipients shown in a Google Sheet.
Functionality:
1. Script checks for any row in "Platforms" sheet where "requestStatus" column is set to "NEW"
2. For each row, create a new email and send it to the email address given in Column E (emailAddress) using GmailApp method. You should fetch the email content from a JSON template file (public URL) and replace any variables in the template, using column headers in the sheet to merge values. For example:
{
"sender_name": "Nicholas",
"sender_email": "name (at) email..com",
"recipient_cc": "name (at) domain.com, name2 (at) domain2.com",
"recipient_bcc": "name (at) domain.com, name2 (at) domain2.com",
"subject": "Test email template",
"body": "Hello, /n I'm writing this email as a sample template and would like to confirm {{companyName}} has received it. /n Thanks, /n Nicholas"
}
3. Once sent, update requestStatus column with "STAGE 1" to show stage 1 has been completed, set the "requestStage1SentOn" column with the current date and time update and set the "requestThreadId" column using the "threadId" of the email just sent - enabling us to use the ReplyTo() method in future.
Functionality:
1. Script checks for any row in "Platforms" sheet where "requestStatus" column is set to "NEW"
2. For each row, create a new email and send it to the email address given in Column E (emailAddress) using GmailApp method. You should fetch the email content from a JSON template file (public URL) and replace any variables in the template, using column headers in the sheet to merge values. For example:
{
"sender_name": "Nicholas",
"sender_email": "name (at) email..com",
"recipient_cc": "name (at) domain.com, name2 (at) domain2.com",
"recipient_bcc": "name (at) domain.com, name2 (at) domain2.com",
"subject": "Test email template",
"body": "Hello, /n I'm writing this email as a sample template and would like to confirm {{companyName}} has received it. /n Thanks, /n Nicholas"
}
3. Once sent, update requestStatus column with "STAGE 1" to show stage 1 has been completed, set the "requestStage1SentOn" column with the current date and time update and set the "requestThreadId" column using the "threadId" of the email just sent - enabling us to use the ReplyTo() method in future.