Guides for Google Sheets™, Docs™ and Calendar™

Plain how-to guides for Google Workspace™. Each one starts with what Google can do on its own, step by step, and only then mentions the add-on I make for the cases Google doesn’t cover.

Google Sheets™ and Google Calendar™

• How to add events from Google Sheets to Google Calendar (and keep them in sync): CSV import, a short Apps Script that updates instead of duplicating, Zapier and Make, and where each stops on updates and deletes.
• How to turn Google Calendar into a timesheet (hours per client): Time Insights and who has it, the .ics export, Google’s free timesheet sample, a script and formulas for hours per client.

Accessibility in Google Docs™ and Google Slides™

• How to make an accessible, tagged PDF from Google Docs: what Google’s PDF export tags today and what it misses for PDF/UA, the Word route, Acrobat Pro, and checking with PAC, veraPDF and a screen reader.
• How to check accessibility in Google Docs and Google Slides: alt text, headings, contrast, Slides reading order and captions, screen reader settings, the ADA Title II dates, and third-party checkers.

Google Sheets™ change history and Google Forms™

• How to see who changed a cell in Google Sheets (and who deleted rows): cell edit history and what it misses, version history and named versions, notification rules, protected ranges, and a free Apps Script edit log.
• Google Form responses not showing in your sheet? How to find them: other response tabs, unlinked forms, deleted, sorted or filtered rows, the 100,000-response and cell limits, CSV download and relinking.

By Caner Kaya, Kayabyte. Questions or corrections: support@kayabyte.dev. See also Kayabyte add-ons for Google Workspace™.

Google Sheets™, Google Docs™, Google Slides™, Google Forms™, Google Calendar™ and Google Workspace™ are trademarks of Google LLC. Kayabyte is not affiliated with or endorsed by Google LLC.