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.

I have excel files that are going to be sent to a specific e-mail address at specific times with specific e-mail subjects. Getting Zapier to detect that the e-mail has arrived is no problem, same as getting it to save it as a google sheet if I want. 

 

However, the critical part of this workflow is trying to get text messages to be automatically sent to each phone number within the excel file. It’s the exact same text message every time and I don’t care which text messaging app is used, but I can’t seem to get this to work on either TextMagic or SimpleText. Any suggestions?

Check out this video about how to create a looping Zap with GSheets…

 

If you’re using TextMagic (or similar app e.g. ClickSend) you should be able to add all the desired recipients to a List, then send the SMS to the List via Zapier, which is a much more efficient solution than creating a looping Zap.

Thanks for your help! I’m going to try the looping method.

 

No matter what I use as the trigger (the incoming e-mail with the attachment or the saved google sheet) I can’t seem to get the “Create Contact” to step into the data in the file and extract anything. All sorts of data values are available, but none of the values that I really need, unless I’m missing something.

It’s a bit more complex to do what you’re trying to do by working with the data within a file.

Essentially you have to convert the attached Excel to a CSV.

After you upload the Excel file to GDrive and convert it to a GSheet, the Zap step will return a version of the GSheet that is a CSV file.

 

Take a look at this article about using the Formatter tool with a CSV file: https://zapier.com/help/doc/how-import-csv-files-formatter

Terms & Conditions