Agenda Doc: Send a Google Form and Create an Agenda

Agenda Doc

I have created an Add-On script that allows you to create a Google Form with the list of agenda items for a meeting and then merge the responses of participants to an editable Google Doc.

I have noticed that many meetings I attend the agenda is created on a Google Doc and shared with those attending the meeting. The document is set to anyone can edit. This allows anyone to insert notes from the meeting during the meeting. It also allows participants to insert comments and discuss ideas in the margins. This system works great especially for virtual meetings where the participants are not in the same room.

One group I am a member of consists of international members. It is always in the middle of the night for someone. This means we can never have everyone’s input at a meeting. Creating a Google Form where the questions are the agenda items allows the group member to weigh in their ideas on each agenda item prior to the meeting.

My Add-On script takes the responses of each group member and creates a draft of the agenda into a Google Doc. Each agenda item is listed, followed by the responses of members. When going over an agenda item during the meeting, the ideas of all members can easily be considered.

Template

alicekeeler.com/agendadoc

Directions

Add-On Menu

After making a copy of the template, use the Add-on menu and choose “Agenda Doc.”
Agenda Doc

Sidebar Menu

A sidebar menu will pop up guiding you through the steps. Choose the “Start” button in the sidebar menu to get to the start screen.
start

Choose the “SetUp” button to format the spreadsheet.
Get Started

Agenda Items

Fill in column B with the Google Form information. Title the Form and give it a description. Suggested question 1 asking for name and suggested question 2 asking for email are pre-populated. These can be edited or changed. While the spreadsheet only shows room for 5 agenda times, you can ask unlimited numbers of questions. Continue to add questions to column B.
form information

Next Steps

Click on the “Next Steps” button after filling out column B.
Next Steps

Google Form

The Add-On script will generate a Google Form from the questions listed in the spreadsheet. Press the “Create Form” button in the sidebar menu. A link to the Google Form will be placed in the spreadsheet. Click on the “Edit Form URL” to make modifications to the Google Form.
Google Form

Send Form

Share the Form with group members by clicking on the “Send” button or by sharing the “Form Link.”

Gather Responses

Wait until group members have responded. Form responses are collected in the same spreadsheet. This eliminates the need to create an additional spreadsheet. Clicking on the spreadsheet icon in the Google Form will open the agenda spreadsheet.

Add-On Menu

Coming back to the spreadsheet after responses have been recorded, again choose the Add-On menu item “Agenda Doc.” Press the “Create Agenda Doc” button in the sidebar menu. Press “Create Doc” on the next menu.
Create Agenda Doc

Agenda Doc

After clicking on “Create Doc,” you will be prompted to enter a title for the agenda document.
agenda title

The agenda doc will list each persons name next to their response. Identify the column of the Form Responses that contains the participants names. If you left the default in the spreadsheet, the 2nd column identifies the participants. Enter 2 into the dialogue box.
Column for participant name

Link to Google Doc

The link to the Google Doc that was generated is placed into the spreadsheet.
Link to Google Doc

The Google Doc is an outline of the agenda topics along with participant responses. Edit the agenda and change the sharing permissions. Share out this Google Doc with meeting participants.
Individual responses

About Your Data PII

App’s use and transfer to any other app of information received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.

Compliance with Google’s Limited Use Policy

AliceKeeler LLC is committed to complying with the Google API Services User Data Policy, including the Limited Use requirements. Our use and transfer of information received from Google APIs adhere strictly to these policies, ensuring data is used only for the purposes necessary to provide and improve the Service.

  • Limited Use of Google User Data: The Service only accesses and uses Google user data in ways that are essential for the functioning and improvement of the Service, and not for independent purposes.
  • Transparency and Consent: We provide clear notice and obtain explicit consent from users before accessing or using their Google user data.
  • Data Minimization: We access only the minimum amount of data necessary from Google APIs to provide our Service.
  • Security Measures: We implement robust security measures to protect the confidentiality, integrity, and availability of Google user data.
  • Third-Party Sharing Restrictions: We do not share Google user data with third parties unless it is strictly necessary for the functioning of the Service and compliant with the Google API Services User Data Policy.
  • Google API Services User Data Policy: For more information about how we comply with the Google API Services User Data Policy, including the Limited Use requirements, please visit Google API Services User Data Policy.

For any questions or concerns regarding our use of Google user data, please contact us at info@alicekeeler.com.

© 2025 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.