Best answer

Autofilling data from a spreadsheet into a zap message

  • 11 June 2020
  • 1 reply
  • 106 views

Userlevel 1

Hello! This is a super specific question (apologies if I don’t explain it very well) 

I am using Zapier to link a  google form response spreadsheet to slack, so that when a new row is added, it sends a notification to a slack channel. Part of the data in the spreadsheet form includes email addresses. I’d like to be able to include in the zap message “New response from ___” and have it autofill the email address the response is from.

Is this something that Zapier can do? I’ve tried searching and been unable to find anything.

icon

Best answer by adamsmartschan 11 June 2020, 21:01

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

Userlevel 5
Badge +6

Hey there @Erik -

 

Adam from Altitude Marketing here. I don’t see why this would be an issue.

 

First, you’ll need to map your form to a Google Sheet, by clicking here: https://www.screencast.com/t/SvxMTr9idI.

 

When you build your Slack action, click on Message Type and use Insert Data: https://www.screencast.com/t/TGrFLB8VMH1. This will bring in variable data from previous steps in your Zap (e.g., New Response in Spreadsheet in Google Forms, or New Row in Google Sheets). As long as one of your questions is “What is your email address?” it should populate a  column in the sheet, which will be available here. Just drop it in and go!

 

If you need a hand, drop me a note or schedule some time: https://calendly.com/adamsmartschan/zapier

 

Thanks!