Hack to Help: COVID-19
Our communities are facing all types of challenges with the coronavirus (COVID-19) outbreak. In the midst of all of it, we’ve been inspired by the small hacks people are making to help in any way they can. So we’ve created this page as a resource for others who might want to help – whether that means creating something, contributing to others' efforts, or simply volunteering your time to those in need.
Help for Organizations and Small Businesses
By Google Creative Lab
A Google Sheets add-on that helps businesses import and manage transcribed voicemails in a simple spreadsheet.
By The Annapolis Small Business Recovery Task Force
An easy way to connect businesses with free retail, legal, banking, IT, and e-commerce support from local volunteers using Google Sheets, Forms, and Gmail templates.
By Nicole He
sms-bot.info is a guide to making a texting bot in Google Sheets using a Twilio phone number in about 30 minutes, no coding required. When people text your bot, it will ask a series of questions that you define, and then save their answers in your spreadsheet.
By Hana Tanimura, Maya Man, José Guizar
Need a quick, contactless way to collect orders, tips, or signatures? A new way to make appointments, or leave reviews? Create your very own Scannable Sign with this simple tool.
By Google Creative Lab
Line Up is a simple app that businesses can use to create and manage a virtual queue. A customer can hold their place in line, then wait a safe distance away until the business notifies them it's their turn.
Help for Everyone Else
Sodar uses WebXR to help visualise social distancing guidelines in your environment. Using Sodar on supported mobile devices, creates an augmented reality two meter radius ring around you.
Glance Back is a daily photo diary that captures moments shared between you and your computer. By interrupting your screen time once a day, the extension invites you to reflect on your current state of mind.
Check out MerchAid from R/GA NY. They’re working with artists/designers to create custom merch with all proceeds going to local small businesses.
Web developer Dan Motzenbecker is working on a simple calculator for your cupboard. Site here.
A slideshow of video tips for remote teaching with Google tools. Guide here.
Web developers have been creating platforms to help support small businesses on sites such as cards.gift, supportnyc.online, helpyourhood.online, and more.
Want to try making your own hand wash timer using Arduino? Makers Lucas Ochoa and Gautam Bose have shared a video here and easy-to-follow instructions here.
Helpwithcovid.com is a site connecting developers who want to volunteer their skills to projects/efforts asking for help.
Naomi Rosenberg of Lighthouse is making the “flatten the curve” graphic more accessible via a tactile braille version. Get the downloadable/printable file here.
Websites like Wash Your Lyrics and Birthday Hands are creative ways to motivate hand washing.
Are you doing something youâd like to be linked here? Post it with #HackToHelp and tag us @ExpWithGoogle.
THOUGHT STARTERS FOR NEW PROJECTS
What are small hacks to share information in your community?
What are small hacks to make information more understandable?
What are small hacks to manage mental health?
What are small hacks to manage physical health?
What are small hacks to manage hygiene/habits?
What are small hacks to help with remote collaboration?
What are small hacks to help with remote education?
What are small hacks to help small businesses in need?
What are small hacks to help nonprofits in need?
These API’s might be useful for exploring ideas around remote work, education, communication, and more:
These API’s might be useful for exploring ideas around habits and well-being, for projects involving desktop notifications, SMS, phone calls, calendar integration, and more:
There are a lot of approaches for creating simple websites for sharing information with your community. Here are a few tools:
↳ (Tip: You can publish a doc to the web via File > Publish)
↳ (Tip: You can host websites directly from your repo)
CORD-19: COVID-19 OPEN RESEARCH DATASET
THE COVID TRACKING PROJECT (APIS AND CSV FILES | GOOGLE SPREADSHEET | PROJECT SOURCE CODE)
COVID-19 DATA REPOSITORY BY JOHNS HOPKINS UNIVERSITY
COVID-19 DATA AND ONLINE DATA CRAWLER BY DXY.CN
TOKYO COVID-19 TASK FORCE WEBSITE (ENGLISH README)
RESTAURANT BOOKING DATASET BY OPENTABLE
KAGGLE: OPEN RESEARCH DATASET CHALLENGE
These might be useful for visualizing COVID-19 related data.
PYTHON (PANDAS, MATPLOTLIB, SEABORN, PLOTLY, JUPYTERLAB)
CORONAVIRUS INFOGRAPHIC DATAPACK
Here are a few more links to popular tools/communities we’re seeing developers use for their some of their projects:
JOIN THE CONVERSATION
Want to see what others are making or share your project? Post it with #HacktoHelp or tag @ExpwithGoogle to help others in the community find your project.