Create automated export of .CSV

Dakota

I want to automatically export a .CSV file (when a form is submitted) from a smartsheet.

Then I want an automated upload of that .CSV into my goggle map.

I am trying to map out the city and state of a location from a form.

Is there a way to complete this?

Andrée Starå

@Dakota

With Data Shuttle, we can automate the sheet export to CSV to, for example, Google Drive or OneDrive.

Would that work?

Andrée Starå

Hi @Dakota

I hope you're well and safe!

Do you only want the CSV of the added row or the whole sheet?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dakota

The whole sheet would be ideal. I do this manually now. I was looking for a more seamless process to do this.

Andrée Starå

@Dakota

We can do that with the premium app, Data Shuttle.

Is that an option?

Let me know if you want to explore, and I'd be happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dakota

Anything is an option if it works. How would Data Shuttle work?

Andrée Starå

@Dakota

With Data Shuttle, we can automate the sheet export to CSV to, for example, Google Drive or OneDrive.

Would that work?

Dakota

Can it also upload the google map to a dashboard?

We are very interested in purchasing this. We are mapping out 2 items. 1.) all equipment and vehicle breakdowns within our company. 2.) all weather delays across the country.

We already have a Smartsheet form they can fill out. The next step would be to see these in a map.

Would Data Shuttle be able to do this? The last thing we want is to purchase this and it not work.

Andrée Starå

@Dakota

I'd be happy to schedule a free discovery call to discuss your needs in more detail.

How does that sound?

Please e-mail me at andree@workbold.com, and we will take it from there.

Have a fantastic weekend!

Dakota

I will bring this up to my boss in our next meeting . If interested I will email you. Thanks you @Andrée Starå

Andrée Starå

@Dakota

Excellent!

If it's not, I'd be happy to continue helping you here in the Community.