Export Report Using Data Shuttle

Sarah123
Sarah123 ✭✭✭
edited 10/17/22 inAdd Ons and Integrations

I'm trying to setup an export of a report using Data Shuttle in Smartsheet (to export it to Google Sheets so that I can combine it with another of my reports) and when I type in the name of the report in Data Shuttle it finds the report but won't let me select it. If I click through the folders for the report I can't find any reports listed. Is there a limitation on using Data Shuttle to export a report? I want to have only certain columns pull into a sheet (I have too many columns and rows to do a link to a cell and there is no way for me to do a DataMesh as I would have to essentially recreate the sheet I'm pulling from). If there's another way to be able to refer to a report that would work too (but I'm not seeing that as a possibility from my searches so far).

Tags:
· Share on Facebook Share on Twitter

Best Answer

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi@Sarah123

    Currently Data Shuttle workflows can only be built with Sheets (not Reports), as you've found.

    You can select specific columns from the sheet in theMappingtab of the Workflow, eliminating any unnecessary columns. You can also setFiltersin the workflow to mimic any filters you had on the Report as well. See:Set filters to control which rows are offloaded

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter
  • Cristian
    Cristian ✭✭

    Can you link to Smartsheet? e.g. the source is a sheet and the target is also a sheet?

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Cristian

    You canuse anoffloadworkflow to offload data from one sheet into a CSV file that attaches to a different Smartsheet sheet, then use a separate上传workflow to upload data from that new CSV file into your second sheet.

    Depending on what you're looking to do, you may want to check out DataMeshinstead, see:DataMesh

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter
  • Sarah123
    Sarah123 ✭✭✭

    @Genevieve P.is there any way to setup an automated export of a report instead of manually going into the report to export?

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Sarah123

    You can set up a recurring email that exports a Report into anExcel file or PDF, see here!

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter
  • mmccar29
    mmccar29 ✭

    @Genevieve P.is there any insight on adding report selection capability to data shuttle this would be so helpful!

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@mmccar29

    I see you Voted on this Product Feedback & Idea thread, here:

    Hi,<\/p>

    I have a Dynamic report that gathers information from the same sheet across a number of projects and displays the lines that meet a certain filter criteria. Currently I have to export this to an excel file and add it as an attachment to the sheet that I want updated by the Data shuttle workflow. It would be good to point Data Shuttle to the report and design and offload workflow to do the first manual step.<\/p>

    Cheers,<\/p>

    Ed<\/p>","bodyRaw":"[{\"insert\":\"Hi,\\nI have a Dynamic report that gathers information from the same sheet across a number of projects and displays the lines that meet a certain filter criteria. Currently I have to export this to an excel file and add it as an attachment to the sheet that I want updated by the Data shuttle workflow. It would be good to point Data Shuttle to the report and design and offload workflow to do the first manual step.\\nCheers,\\nEd\\n\"}]","format":"rich","dateInserted":"2022-12-06T04:31:56+00:00","insertUser":{"userID":148119,"name":"Edward Sheaf","url":"https:\/\/community.smartsheet.com\/profile\/Edward%20Sheaf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T05:48:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/98441\/allow-data-shuttle-to-use-reports-to-offload-data","embedType":"quote","name":"Allow Data Shuttle to use reports to offload data"}"> https://community.smartsheet.com/discussion/98441/allow-data-shuttle-to-use-reports-to-offload-data

    If there are updates in this are the Status will be changed and you'll receive a notification.

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter

Categories

I understand. Unfortunately, there is no other option that I see. One thing to make it easier for you to add the name is to have a helper column in the source sheet with a formula to identify duplicates. If there is a record with no duplicate (i.e., a new name added), you can get notified through a workflow and use that to add the name to your metric sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106975,"type":"question","name":"Case sensitivity when using data mesh","excerpt":"I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also…","snippet":"I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including…","categoryID":343,"dateInserted":"2023-06-27T19:39:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T20:09:07+00:00","insertUserID":114017,"insertUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":114017,"lastUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3375793110,"url":"https:\/\/community.smartsheet.com\/discussion\/106975\/case-sensitivity-when-using-data-mesh","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106975\/case-sensitivity-when-using-data-mesh","format":"Rich","lastPost":{"discussionID":106975,"commentID":382692,"name":"Re: Case sensitivity when using data mesh","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382692#Comment_382692","dateInserted":"2023-06-27T20:09:07+00:00","insertUserID":114017,"insertUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T20:09:23+00:00","dateAnswered":"2023-06-27T20:09:03+00:00","acceptedAnswers":[{"commentID":382691,"body":"

Perfect. Thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106958,"type":"question","name":"Datamesh very slow to update","excerpt":"Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?","snippet":"Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have…","categoryID":321,"dateInserted":"2023-06-27T15:05:03+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T21:09:27+00:00","insertUserID":161700,"insertUser":{"userID":161700,"name":"Jagdeep","url":"https:\/\/community.smartsheet.com\/profile\/Jagdeep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:01:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":15741,"lastUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:07:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3375780270,"url":"https:\/\/community.smartsheet.com\/discussion\/106958\/datamesh-very-slow-to-update","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106958\/datamesh-very-slow-to-update","format":"Rich","tagIDs":[219,334,381],"lastPost":{"discussionID":106958,"commentID":382703,"name":"Re: Datamesh very slow to update","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382703#Comment_382703","dateInserted":"2023-06-27T21:09:27+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T21:07:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T21:04:31+00:00","dateAnswered":"2023-06-27T19:57:59+00:00","acceptedAnswers":[{"commentID":382687,"body":"

Hi @Jagdeep<\/a> - Unfortunately, my experience has been that Datamesh \"Immediate\" can take up to 5 minutes (perhaps more).<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":381,"urlcode":"DataMesh","name":"DataMesh"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5417,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet

  • Orderable Charts

    Good morning, I've done several searches here but now I'm going in circles. I have a sheet with records of usage of certain scripts we have. Each row has the user name, the script they used and the time they saved by using each script. My goal is to create a dashboard with two bar charts: user name vs total time savings…

  • Case sensitivity when using data mesh

    I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also…

  • Datamesh very slow to update

    Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?