Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

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! 

 

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