Google Docs AutomationDifficulty: Intermediate⚡ Nightly Trigger

Auto-Append Today's Meeting Notes to a Master Google Doc

Extracts today's completed calendar meetings and appends meeting headers, attendee lists, and blank action item checklists into an executive Master Meeting Doc.

Required OAuth Scopes: https://www.googleapis.com/auth/calendar.readonly • https://www.googleapis.com/auth/documents
Code.gs (Apps Script V8 Runtime)
function appendMeetingNotesToDoc() {
  const docId = 'PASTE_MASTER_NOTES_DOC_ID_HERE';
  const doc = DocumentApp.openById(docId);
  const body = doc.getBody();
  
  const today = new Date();
  const events = CalendarApp.getDefaultCalendar().getEventsForDay(today);
  
  body.appendParagraph('--- Meeting Notes for ' + today.toDateString() + ' ---')
    .setHeading(DocumentApp.ParagraphHeading.HEADING2);
    
  events.forEach(evt => {
    body.appendParagraph(evt.getTitle()).setHeading(DocumentApp.ParagraphHeading.HEADING3);
    body.appendParagraph('Time: ' + evt.getStartTime().toLocaleTimeString());
    body.appendParagraph('Action Items:');
    body.appendListItem('Action 1: ');
    body.appendListItem('Action 2: ');
  });
  
  doc.saveAndClose();
}

Line-by-Line Code Explanation

Line 2-4: Opens master Google Doc.
Line 6-7: Queries calendar events for today.
Line 12-19: Formats headings and action item checklists into the document body.

Step-by-Step Setup & Deployment

  1. Create a master Google Doc for team meeting notes and paste its ID in Line 2.
  2. Set a time-driven trigger to run at 5 PM daily.

Best Practices for Quota & Rate Limit Management

When deploying this automation in Google Workspace, adhere to these operational principles:

  • Batch Reads & Writes: Never execute getValue() or setValue() inside loops. Read ranges into memory in 1 call, process arrays in V8 memory, and commit changes with a single setValues() call.
  • Execution Timeouts: Apps Script terminates scripts exceeding 6 minutes. For multi-thousand row datasets, implement batch pagination with resume timestamps stored in PropertiesService.
  • OAuth Permissions: Scope your manifest (appsscript.json) narrowly to prevent security prompts from alarming external team members.

Frequently Asked Questions

Is Google Apps Script completely free to use?

Yes. Google Apps Script is built into all free Google accounts and Google Workspace editions. There are no server fees or subscription costs for running scripts within daily quotas.

Can I run this script on an automated schedule without keeping my computer on?

Yes. Time-driven triggers execute on Google's cloud infrastructure. Your script will run reliably even when your computer is closed or offline.

More Google Docs Automation Snippets