Automating Gmail to Google Sheets using Zapier

In today’s digital world, automation saves time and reduces manual errors.

If you regularly collect data using Google GMAIL, you probably spend time manually copying responses into Google Sheets.

In this article, I’ll show you how I automated this entire process using Zapier — a no-code automation platform that connects your favorite apps — and then documented my Zap on GitHub for others to reuse.

⚙ What is Zapier?

Zapier is a powerful automation tool that lets you connect two or more applications together to perform automated actions, called Zaps.

Each Zap has two parts:

Trigger → The event that starts the automation
Action → The task that happens automatically

For example

When a new Google Form response is submitted, → Add a new row in Google Sheets.

🛠 Step-by-Step Setup

Step 1. Create a Zap

Go to Zapier.com.
Click Create Zap.
Choose your Trigger App → Google Forms.
Select the Trigger Event → New Response in Spreadsheet.
Connect your Google account and choose your Form.

Step 2. Add Action

Add Action App → Google Sheets.
Select Action Event → Create Spreadsheet Row.
Connect your Google Sheet and map the fields (Form Question → Sheet Column).
Click Test Action → You’ll see your sample data appear in Sheets!

Step 3. Publish Your Zap

Once tested successfully, click Publish to activate your Zap.

Now every new Google Form submission will automatically add a new row in Google Sheets — no manual work required.

Step 4. Share Your Zap as a Template

Open your Zap → Click Create Template.
Zapier will generate a public link that others can use.
Copy that link — it looks like this: https://zapier.com/shared/d68ed54b4661ce0bcd88d7510687d803c4656df0

Step 5. Add Action

Add Action App → Google Sheets.
Select Action Event → Create Spreadsheet Row.
Connect your Google Sheet and map the fields (Form Question → Sheet Column).
Click Test Action → You’ll see your sample data appear in Sheets!

Step 6. Upload Zap to GitHub

Go to GitHub.com

→ Create a new repository.

Add a file named README.md.

Paste the following markdown content:

# Google Form → Google Sheets Automation (Zapier)

🔗 Zap Template

Use this Zap: [Click here to open in Zapier]( https://zapier.com/shared/d68ed54b4661ce0bcd88d7510687d803c4656df0)

🧠 What this Zap Does

Automatically sends Google Form responses to Google Sheets.

⚙ Connected Apps

Google GMAIL
Google Sheets

🪄 Trigger

New Form Response Submitted

🚀 Action

Add Row in Google Sheet