About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How do I set up my Google Sheet so that data goes in the right places?

  • 10 August 2022
  • 1 reply
  • 80 views
T

Hi everyone, I'm trying to setup a zap between gmail and google sheets but it's not working quite how I'd like.

I've created a spreadsheet to track our incoming business enquiries (see attached image). The spreadsheet has been setup to calculate various factors (in “enquiries column”). As all our enquiries come through our emails, I'd like to setup a zap that adds these emails to this spreadsheet when they come in so I don't have to do it manually. I've had a play around and setup a couple of zaps, but I'm having the following issues and it's not working how I'd like:

  • The email gets added to the first column (I'd like to select the column it gets added to)
  • The email gets added to a random row. I'd like to stipulate which row to start on and have it continue as a new row for each one. 

If anyone can help me get this setup properly it'd be much appreciated! 

 

icon

Best answer by Danvers 11 August 2022, 11:40

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Danvers
Userlevel 7
Badge +12

Hi @Takirua Tandem Media!

Google Sheets can be very fussy, and if a spreadsheet isn’t set up in a certain way then it’s likely that your Zap wont act in the way that you expect. In this case, it’s likely that the issue is caused by the w/s and Enquiries columns and the enquiries header at the top, as they look like merged cells. 

If you’d like to have a sheet that looks like this, I’d recommend setting up a separate one for your Zap. The sheet for your Zap should have:

  • a single column for each piece of information that you need
  • a single header row (ie just the first row of the sheet has the names of the fields that you need)
  • no merged cells and no empty rows in the middle of the information (ie you can have blank rows at the bottom, but don’t have an empty row then a row with data in it). 

Have the information from Gmail go to that simple sheet and then create a different sheet in the same work book and use lookup functions to pull in the information that you need in the format that you’d like it to be. 

I hope that helps, let us know how you get on!

Terms & Conditions