Back to all projects

Google Apps Script Workshop

Help Give A Day Global by running a workshop to teach them how to use Google Scripts to automate tasks and processes in various Google Apps.
Give A Day Global
San Francisco, CA, USA
Give A Day Global
Unfollow
Log in to follow
Give A Day Global
San Francisco, CA, USA

0

Live Projects

0

Matched Projects
0 Followers
Cause
Human services
Skills
Engineering Web development

Posted May 26th

Google Apps Script Workshop

Project details

What we need
  • A workshop that teaches users how to write and troubleshoot a script connecting multiple Google products
  • One functional prototype of an Apps Script, such as mail merge, form automation, etc. by the end of the workshop
  • Resources for learning further about the topic as well as existing ready-to-use scripts built by other developers
What we have in place
  • We currently use Google apps and Google forms - it is the backbone of our organization. We are a very small team so we can get you any resources you need to help us improve.
How this will help
This project will save us $2,752 , allowing us to provide volunteer coordination for 200 international travelers, benefitting the organizations they serve.

Streamlining our internal systems will help us to serve the international nonprofit organizations that we work with, and travelers who wish to volunteer with them. We are a startup organization - every contribution is critical to our success.

Project plan

P
Prep: Goals & Format
  • Volunteer Manager outlines Organization’s current Google Apps setup and shares challenges faced by staff in using Google Apps
  • Volunteer Manager to share logistical information such as number of workshop attendees and current workflows that involve Google Apps
  • Professional suggests format of workshop (Skype/in person/web conference)
1
Milestone 1: Logistics & Communications
  • Volunteer Manager and Professional agree on time and date for workshop
  • Volunteer Manager and Professional agree on one specific functional Apps Script prototype that will be covered in the workshop (e.g. mail merge, form automation, etc.)
  • Professional creates detailed agenda for workshop outlining topic as well as structure of training
  • Professional works with Volunteer Manager to create a functional prototype of an Apps Script to be covered during training
  • Professional shares agenda, Apps Script prototype and preparatory materials (if any) with Volunteer Manager
  • Volunteer Manager communicates opportunity and shares agenda and preparatory materials with staff, and collects RSVPs
2
Milestone 2: Workshop & Resource Sharing
  • Volunteer Manager informs the professional of the number of RSVPs along with any questions that surface
  • Professional conducts workshop, answers any questions and provides recommendations for finding assistance going forward
Show more

About the org

Give A Day Global
Unfollow
Causes
Human services International affairs
Posted by
Kerry R
Kerry R.

Co-Founder and Executive Director

Our mission

To connect international travelers with daylong volunteer opportunities, and to help our nonprofit partner build capacity and expand their networks of support.

The pixel