Email import via Zapier

I am auto-forwarding certain emails from Outlook to a Smartsheet list via Zapier.

Everything comes across fine but certain data fields seem limited in space. The body of the email doesn't fully transfer. It seems there is a character limit to either the Zapier forward or to Smartsheet. How can I get the complete email into Smartsheet?

Thanks

Find more posts tagged with

Integrations

Community Platform

Importing and Exporting

Email Notifications

Comments

Mike L.

I use the smartsheet add-in for outlook. Select an email click the add-in button and use the search box to find the target sheet then target row. The email body is transferred to the comments field and documents go to the attachment field. Some formatting is lost but it is usually easy to follow. As far as I know the entire email contents are transferred into a single comment. This is helpful for creating a task from an email or for providing comments to a task. Where it falls short is that you can only go from outlook to smartsheet You can transfer emails to a row but from there you cannot click on anything to forward or reply to the message. The information is stored but it is no longer a valid email file format. Does zapier do this any different?

HowardB

thanks for your reply. I have the Outlook add-in but you have to select the email manually -- as far as I can tell. I am using Zapier to pull the emails as they come into a folder and automatically populate a smart sheet. The whole idea is to get out of the manual selection mold. the problem is that when the emails get pulled over to Smart Sheet the body text is truncated. I will see if the manual button works the same way.

Thanks

Mike L.

Thanks for the info. I had no idea that you could do something like this. Thanks for sharing your process.

Alex Zaliznyak

hi, I'm trying to understand how much control we have over what fields come from Outlook and how they populate the sheet once the add in is utilized. For example, I would like the "From" field in the email to auto populate the "requestor" column on my sheet so we know who the request came from. can somebody help me understand this further. thank you

Sign in to join the conversation!

Quick Links

Trending discussions

DocuSign integration suddenly not working with contacts that display the name instead of email.
I've had a DocuSign integration working for a while now. Today, I go to use it and it doesn't work because it sees invalided characters. Upon researching, I have discovered that if the contact field displays the person's email instead of their name the integration works. So it's like DocuSign used to be able to use the…
Checking provisional members on Smartsheet for USM model
Hi smartsheet community! I wanted to check if there is any way by which we can check who all are provisional members in our existing user list. Kindly note that we have not ye to move to User Subscription Model. Thank you for your response!
Pivot App doesn't allow date columns?
I have a source sheet that has the following columns: Project Code , Milestone and Milestone Date . I want to use the Pivot app so that it gives me a row for each project code, columns of Milestones and the corresponding dates for those milestones. Am I correct in understanding that the Pivot app cannot output dates? I…