Google Docs - Automatically Fill Live Form from Webpage

Other Questions Google docs
1

I have a webpage dedicated to upcoming events (for instance, an event page like ‘5493.html’). This webpage contains details including the event title. I’ve created a Google Docs form that connects to a spreadsheet for responses.

My problem is that I need to extract the event details from ‘5493.html’ and automatically fill the corresponding fields in my Google Docs form. Specifically, I want fields such as:

  • Event Title: [should populate from the ‘5493.html’ page]
  • Event Date: [should populate from the ‘5493.html’ page]

I want to share this form link, allowing others filling it out to have these details pre-filled to eliminate errors from manual entry.

While I’m aware of manual link adjustments, are there automated methods available for this task? Thank you!

2

Another approach could be using Google’s Apps Script. You can write a script that fetches the event data from your webpage (e.g., using fetch or UrlFetchApp) and then writes it directly into the Google Form fields. By triggering the script whenever a new event is added or updated, you automate the data transfer process. This avoids manually editing links, providing a seamless way of keeping your form updated with accurate data. You can schedule the script to run periodically or set a trigger to update the form in real-time.

3

hey! have you thought about using your web server to parse the event data using a script (like in python)? you could extract the event info and send it via a url to prefill the form fields. it’s a bit of coding but could do the trick!