VMS Google Workplace Automation

Save to Favorites

VMS Google Workplace Automation

Commitment:

12-months, 1 hour a week.

Expectation

Automate and optimize workflows within Google Workspace (Forms, Sheets, Docs, Gmail).

Organize and maintain scripts and related documentation.

Attend a 30-minute meeting once a week.

Role Overview:

This role is responsible for building and maintaining automations using Google Apps Script to streamline workflows for the Volunteer Management System (VMS), improve reporting, and reduce repetitive tasks. The engineer will also organize technical documentation and ensure processes are easy to replicate and build upon.

Compensation:

Volunteer, or 40 Greenstand Impact tokens a month

Reports to:

VMS product and project manager

Collaborates with:

VMS Lead

AREAS of RESPONSIBILITY

The Volunteer Management System (VMS) at Greenstand benefits from automation to streamline volunteer onboarding, data tracking, task coordination, and communication. This role will enhance the VMS by developing efficient automation workflows using Google Workspace tools and scripting.

This role is responsible for:

• Designing and deploying Apps Script-powered automation for internal tools like Forms, Sheets, Docs, and Gmail.
• Managing triggers, workflows, and scripts that move data and automate key touchpoints.
• Organizing technical documentation and training materials for these systems.

Required tasks

Google Forms & Sheets Automation:

• Create and maintain volunteer intake forms, feedback surveys, and connected Sheets with automated formatting, tagging, and data routing.

Apps Script Development:

• Develop and maintain scripts to automate approval flows, status updates, notifications, and document generation.

Email & Calendar Workflow Automation:

• Set up workflows that trigger personalized email responses, task assignments, and meeting invitations based on volunteer form submissions or system events.

Maintain Documentation & Structure:

• Ensure all automation processes are clearly documented in Gitbook or Google Docs, including logic, triggers, and integration points.

Troubleshoot & Optimize:

• Proactively monitor automation scripts for errors, inefficiencies, and outdated workflows.

Collaborate with the VMS Team:

• Gather needs from VMS leads and align automation efforts with volunteer coordination goals.

QUALIFICATIONS/EXPERIENCE/KNOWLEDGE:

• Experience with Google Apps Script (JavaScript-based) and automating Google Workspace tools.
• Strong understanding of Google Forms, Sheets, Gmail, and Calendar workflows.
• Comfortable working with triggers, web apps, and dynamic form/sheet integration.
• Strong attention to detail and technical documentation skills.
• Ability to work independently and communicate clearly in a remote team environment.
• Experience in nonprofit or open-source projects is a bonus.

Welcome to Greenstand!

Thank you for your interest in volunteering with Greenstand and for expressing your willingness to contribute as a product designer. We truly appreciate your enthusiasm for our cause and your desire to make a difference.As a volunteer, you'll have the opportunity to work closely with our team, gain valuable experience, and make a positive impact on the environment.

Next Steps...
Step 1: Complete Our Volunteer Registration Form: Tell us about your skills, goals, and volunteer expectations. - https://docs.google.com/forms/d/e/1FAIpQLSeEmwekGZ5tcc5sVhsgMDf-KEDBMtZYoCYAmxyxrOPv5w0WKA/viewform
Step 2: Join Greenstand Slack: Introduce yourself in the #community-intros channel and indicate the specific role you are interested in. We can’t wait to meet you! - https://join.slack.com/t/ greenstand/shared_invite/zt- 2uvjbmkea- zI8BRhwsAUZp0PQz1Knk~w
Step 3: Schedule Your Orientation: Wait for a Volunteer Onboarding Coordinator who will help you get involved in the community!We look forward to making the world a greener place with you!

Sincerely,
The Greenstand Team