Back to all projects

Google Apps Script Workshop

Help The HOPE Program by running a workshop to teach them how to use Google Scripts to automate tasks and processes in various Google Apps.
The HOPE Program
Brooklyn, NY, USA
The HOPE Program
Unfollow
Log in to follow
The HOPE Program
Brooklyn, NY, USA

0

Live Projects

6

Matched Projects
0 Followers
Cause
Employment services
Skills
Engineering Web development

Posted December 17th

Share this project:
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
Additional details

We currently have spreadsheets tracking our building inspection process; we would like to add in a field that automatically looks up building addresses and updates the sheet with the US Representative, State Senator, Assembly Person, and City Council Member.

We would like to see if there's a way to query Google API (https://developers.google.com/civic-information/) and auto-populate fields in the sheet with the names of elected representatives.

What we have in place
  • We currently have an existing spreadsheet that we would like to add fields to, which should make it easy for you to get started. We also have an idea for the source of data, and the ability to provide any other information you need.
How this will help
This project will save us $2,752 , allowing us to allowing us to reinvest in our workforce training programs and provide more opportunities for our students to thrive.

This project will allow us to better connect with elected representatives, an important aspect of outreach for our climate change mitigation and workforce development efforts.

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

The HOPE Program
Unfollow
Causes
Employment services Community & economic development Environment
Posted by
BR
Bhavya R.

Operations Manager

Our mission

To empower New Yorkers living in poverty to achieve economic self-sufficiency through employment and career advancement

Testimonials

Read the Impact Story
Mariya did a fantastic job of creating a tool that will save us time and clearly walking us through what we needed to know to set it up. She also provided step-by-step documentation that we will be able to use with other team members as well. Thank you for all your help Mariya!
Bhavya R.

Operations Manager

Google Apps Script Workshop Project

(No testimonial has been submitted by Mariya)
The pixel