Session 1:

AI & Apps Script

Schedule

Session 1

9:30 - 11:00

Fill out this form

Session 2

11:10 - 12:00

Session 3

1:15 - 2:20

ChatGPT and Gemini for Apps Script

I have been using mostly ChatGPT to help with the many projects I do with apps script. It gives me a great foundation to start working on the project. I will share some of the dialogs that I have had with chat in solving complex issues in scripting and writing complex sheets formulas. However there are pitfalls and often the responses given do not work, so one needs to develop an understanding of scripting to know how to trouble shoot the issues and get a working result.

We will discuss the issues about using AI to help you code, then we will build a system together to use a form to add evemts to a google calendar.

Using ChatGPT to help you code

Here is my conversation with chat about building a calendar/form/sheet system
Quite interesting to follow the thread of this script to see how together, chat and I came to a fully working version that I wanted.
Gemini Response to request

Neither of these original responses worked to add the data to my calendar

Add some console.log items to the script to help trouble shoot

Troubleshooting - executions codes to find the errors

Fixed working Code

function onFormSubmit(e) {

const formData = e.namedValues;

const name = formData['Name'][0];

const description = formData['Description'][0];

const startDateTime = new Date(formData['StartDate'][0]);//i had to fix this

const endDateTime = new Date(formData['EndDate'][0]);//I had to fix this

console.log(name)

console.log(description)

console.log(startDateTime)

console.log(endDateTime)

const calendarId = 'YOUR CAL_ID HERE'; // Replace with your calendar ID

const calendar = CalendarApp.getCalendarById(calendarId);

const event = calendar.createEvent(name, startDateTime, endDateTime, { description: description });

Logger.log("Event created with ID: " + event.getId());

}

Other Example APPS Scripts

Form To Calendar Script from Sheet

Form to Slide

Script Doc

/**This script will connect a form to a slide presentation.

* There are some changes you need to make to this script to get it to work with your slide deck.

* This script is attached to the form

* The Question and Response fields need to be added to the slide as text boxes and have those words

* (or other words ) that will be replaced with the contents of the form responses

* Timothy Welch

function audienceResponse(e) {

const slideDeckURL = 'https://docs.google.com/presentation/d/1_FELrNGM58YYZZRWadrnuPxpx_k89KQBzH94Ygx1Wr0/edit#slide=id.g26d2005f8f1_0_16';//replace with your slide deck URL

const openPresentation = SlidesApp.openByUrl(slideDeckURL);

//replace audienceSlide with the slideID you want to duplicate

const audienceSlide = openPresentation.getSlideById('g26d2005f8f1_0_16');//replace with your slide ID

const newSlide = audienceSlide.duplicate();

const newSlideId = newSlide.getObjectId();

var items = e.response.getItemResponses();

const changeSlide = openPresentation.getSlideById(newSlideId);

changeSlide.replaceAllText('Question', items[0].getResponse());//the script will change the word question with the form response in the first form item

changeSlide.replaceAllText('Response', items[1].getResponse());//the script will change the word response with the form response in the second form item

}

Report abuse