Skip to content

##### You said:

i want to you to write an app script which would run one every time the form is being filled. i want you to send email on the email id as mentioned in "c". once the email is sent update the staus as sent and update time. The subject of the email woul be "Rescources for the session" Hi Please Find the Link to down load the rescources "Give me Place Holder for Google Drive" Lets make best of the time to have more of the session. happy to Connect on Linkedin (give me a place holder of the Linkedn ) write a formal email i am addressing to CAs.

###### ChatGPT said:

Below is a complete Google Apps Script that will:

- Run every time the Google Form is submitted

- Read the respondent email from Column C

- Send them a formal email (for CAs) with placeholders for Google Drive + LinkedIn

- After sending, update:

  - Status (Column D) = `Sent`

  - Time (Column E) = current date-time

## ✅ Apps Script Code (paste as-is)

> Go to Extensions → Apps Script in the same Google Sheet (Form Responses sheet) and paste this code.

## ✅ How to make it run automatically (important)

1. In Apps Script, click Triggers (⏰ icon)

2. Add Trigger

3. Choose function: `onFormSubmit`

4. Event source: From spreadsheet

5. Event type: On form submit

6. Save → Google will ask for authorization → allow.

## Where to put your links

Replace these two lines in the script:

with your actual links.

If you want, I can also format Column E to show only time (HH:MM) or date+time in IST format, and I’ll adjust the script accordingly.

ChatGPT can make mistakes. Check important info. See Cookie Preferences.
Select Certificate
Smartcard / Token User Pin
User PIN:
Signer.Digital
Signer.Digital - Confirm Key Listing / Usage
Current Domain
is trying to detect smartcards connected, or read certificate or use key for signing/encryption. Please select your option.
Licensed Sites

Website | License Status | Features | Action
--- | --- | --- | ---