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?
With Data Shuttle, we can automate the sheet export to CSV to, for example, Google Drive or OneDrive.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
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!
✅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!
The whole sheet would be ideal. I do this manually now. I was looking for a more seamless process to do this.
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!
Anything is an option if it works. How would Data Shuttle work?
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.
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 [email protected], and we will take it from there.
Have a fantastic weekend!
I will bring this up to my boss in our next meeting . If interested I will email you. Thanks you @Andrée Starå
If it's not, I'd be happy to continue helping you here in the Community.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.