Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools

Prath M
Prath M
9,631 Points
Posted by Prath M
Prath M
9,631 Points

Where do I start on the server-side to make a simple form that fetches a URL from a Google spreadsheet?

I am working on a program so a user can enter a youtube url into a google spreadsheet and under a category and that is communicated to the front of the site and shows up as a new link in the videos array.

I think there is a way to do this using Google's Apps Script but I got lost when I get to the concept of having the url being interpreted as html.

I know how to make the html form and basic javascript but don't know where to start on the server-side. Any guidance is much appreciated!

1 Answer

Iain Simmons
Iain Simmons
Treehouse Moderator 32,305 Points

Maybe have a look at the Apps Script Excution API.

You could set up your script and then using some server-side scripting, execute the script and get the response you need before rendering the desired result in HTML.

Alternatively, instead of trying to make your own form, depending on your requirements you could try and use Google Forms, since they already integrate well with Google Sheets. Here's an example from Google's documentation: Quickstart: Managing Responses for Google Forms

Prath M
Prath M
9,631 Points
Prath M
Prath M
9,631 Points

Awesome, thanks Iain!