This project is in progress
Matched with Rodrigo A
Matched with
Rodrigo A.

G Suite Script Workshop

Help Jibu by running a workshop to teach them how to use Google Scripts to automate tasks and processes in various Google Apps.
Colorado Springs, CO, USA

Posted July 7th

Share this project:
G Suite 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 have G-Suite setup for all our employees, which should make it easy for you to get started. We also have an IT Head to implement any changes, and the ability to provide any other information you need.
How This Will Help
This project will save us $2,752 , allowing us to utilise our G-Suite more. This will increase our collaboration as a company.

The basics G-Suite features have many a times not been sufficient to solve our problems. For example the ability to create Google Docs from Form Responses. We have had to do a lot of manual work where automation is actually possible.

Project Plan

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)
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
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

Our Mission

Capitalize and equip entrepreneurs to establish affordable access to drinking water and other impactful products.

What We Do

Jibu is a social franchise, pioneering a powerful new business model to ensure access to basic human needs like clean drinking water. Currently serving East Africa (Kenya, Rwanda & Uganda), Jibu equips first time and seasoned entrepreneurs to own clean water franchises, becoming the solution, one neighborhood at a time.

Learn more: