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

Anyone getting JIRA API errors using the connector?
We are using the Jira/Smartsheets connector and got this error: Invalid response from JIRA. statusCode: 410, reasonPhrase: Gone The requested API has been removed. Please migrate to the /rest/api/3/search/jql API. A full migration guideline is available at Looks like the connector needs to be updated. Anyone know anything…
Dirty save - #BLOCKED/Invalid Value issue when using integration until manually save the sheet
Hello everyone, We’re facing a critical issue in one of our Reports. We use integration and it adds values to the sheets. The corrected values don't seem to auto-save. Formulas in sheets first show #BLOCKED/Invalid Value, then if we refresh the sheet - it updates to the correct numbers. The save button is active even…
Smartsheet for Google Drive doesn't seem to be available anymore
Trying to access Smartsheet for Google Drive and it seems it's not available anymore: https://workspace.google.com/marketplace/app/app/46145466229 Also the app is not listed when searching on Google Marketplace.