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.
Best answer by adamsmartschanView original
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