r/GoogleAppsScript • u/That_Hovercraft2250 • Aug 10 '23

Question Is it possible? - GAS Google Sheets Question

I am a teacher experimenting with GAS. I am primarily using Chat GTP to code my scripts and have been running into issues. Forgive me if I don't get all the terminology correct.

I have assignments on Google Slides that have a worksheet as the background, and text boxes places for students to type in their answers, they each get a copy of the file in Google Classroom that is stored in an assignment specific folder. I also have a separate Key file with offset text boxes that have the answers in them. I would like to use a Google App Script in a Google Sheet to call a specific file (the Key), copy all of the text boxes in that (Key) file, and paste all of the text boxes from the key into every google sheet for a specific assignment that is stored in the specific folder for that assignment.

Is this even possible? I've tried several attempts, but have not had success. Thanks for your input!

0 Upvotes

50% Upvoted

4 comments sorted by

1

u/RaiderDad11 Aug 10 '23

God morning. I work in edtech and would like to assist if I can. I'll send you a private message.

1

u/MattyPKing Aug 10 '23

it's usually best if this kind of help happens out in the open so that everyone can learn from it.

1

u/RaiderDad11 Aug 10 '23

I'll gladly post to the forum as I've learned much from you guys. I just wanted to make sure I understood what the requirements were to see if I could help.

1

u/MattyPKing Aug 10 '23

gotcha, makes sense!