how to receive excel file notification for the newest update in smartsheet ?

Hello,

for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that email ? or to some specific server location ?

Thanks in advance

Valerie

Find more posts tagged with

Publish

API and Developers

Education

Reports

Integrations

Support

Solution Center

IT & Operations

Product Development

Conditional Formatting

Project Management

Comments

Andrée Starå

Hi Valerie,

I can think of a few ways to set this up.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

vnguyen76621

Hi Andree,

(1) the first image : is the current email notification that everytime I add/update new record in smart sheet

(2) the second image : which I expect to receive an excel file ( sample as picture) which including all new /update record in that email attachment; or it is better if the excel file could export to send to server location

Please let me know if you have any question

thanks in advance

Valerie

email notification - newor update records.JPG

notification as an attachment with including the new-update records.jpg

Andrée Starå

Hi Valerie,

I would probably set this up with the help of a service like Zapier or similar.

Do you want to include both added and updated rows?

Would that work?

Best,

Andrée

vnguyen76621

I would like to have only the added one, not the update for now since it would cause the duplicate project if we send the update again. how does Zapier work ? is that another integration with smartsheet ? Thanks in advance

Andrée Starå

Happy to help!

Zapier is a service, and with it, you can connect Smartsheet to thousands of other web apps.

Hope that helps!

Best,

Andrée

vnguyen76621

Thanks Andree for the information,

do you have any ideas or estimate about the cost of this integration ? please let us know

Thanks in Advance

Valerie

Andrée Starå

Happy to help!

I don't know why I didn't think of this before, but it could probably be set up with a report instead.

The report could be set up to send as an attached excel file.

Would that work?

Best,

Andrée

Andrée Starå

Hi Valerie,

How did it go? Did you get something set up?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Potential recently introduced bug on Create Webhook call? (POST /webhooks)
Our Smartsheet integration has occasional need to create a webhook before it knows the ultimate URL for the callback. For several years, we have done this by supplying a dummy URL to the CreateWebhook (POST /webhooks) API and then before we verify that webhook, we update the URL with the POST /webhooks API and set it to…
linksOutToCells return as null
I've tried using the C# SDK and directly to the API. In both cases the get specifies include=crossSheetReferences when getting the sheet. The Rows are returned and the Cells contain the correct data but in each case the linksOutToCells is null. What am I missing?
Does a view-only user need a license to use the API?
Hello everyone, I will need to use Smartsheet API to ingest data from Smartsheet to an object storage. To do that, my client will create a view only account for me. If I understand correctly, to use the API the account needs to be licensed, so we will need to pay for this "service account". That is correct?