Connect Smartsheet with Datastudio
Hello everyone,
I have a use case and I don't know how to proceed and find the best way to solve my problem.
Here is the use case :
I have a sheet in Smartsheet for request management.
I would like this sheet to automatically be pushed into a Datastudio report.
I was thinking about the following options, but maybe do you have some suggestions or feedback on this use case ?
- Use a dedicated connector made by a third party app (not free)
- Use live data connector ?
- Create an API development (extraction toward a Google Sheet that is the Datastudio data source)
- Use Data Shuttle to export the sheet into Google Sheet (currently we can only do an export on Excel or csv if I am right)
Please let me know if you have any ideas,
Have a great day, Corentin
Answers
-
Alex Argumedo ✭✭✭It depends on your resources, API is the best from my point of view, because it will allow me to parse data at will due to a few restrictions (https://help.smartsheet.com/articles/770623-exporting-sheets-reports-from-smartsheet#google) in order to send to Google Sheet, you can extract the data from smartsheet, convert JSON to what ever is the best format for Google Sheet to consume it.
-
Corentin Dal Farra ✭✭✭✭✭✭
Thank you for your reply,
I will look at the API possibility in that case.
Have a nice day,
Corentin
Categories
- Data Shuttle: You mentioned you work for a small company and already use SCC. If it's been a while since you talked with your account rep, I suggest contacting them just to see what they can offer. I've seen them offer much more attractive pricing to small companies lately. (One company I'm working with was able to upgrade to Advance for a fraction of what they were quoted a few years ago.)<\/li>
- Zapier. https:\/\/zapier.com\/apps\/smartsheet\/integrations\/excel--onedrive<\/a><\/li><\/ol>
www.linkedin.com\/in\/juliefortney-pmp-smartsheetpartner-lssblackbelt<\/a><\/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":["discussion","question"]},"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":108270,"type":"question","name":"Hiding Row Comments in a report in Portfolio Workapp\/Project Workapp","excerpt":"Hello all, Does anyone have any ideas on how I might be able to hide row comments in a report that is in an individual project Workapp within a control center Portfolio Workapp? I have hid the comments column in my report but my my external partners are still able to with view access to click on the view details pane and…","snippet":"Hello all, Does anyone have any ideas on how I might be able to hide row comments in a report that is in an individual project Workapp within a control center Portfolio Workapp? I…","categoryID":343,"dateInserted":"2023-07-28T18:01:06+00:00","dateUpdated":null,"dateLastComment":"2023-08-01T18:07:36+00:00","insertUserID":11482,"insertUser":{"userID":11482,"name":"Lori Khoury","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Khoury","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T04:35:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":11482,"lastUser":{"userID":11482,"name":"Lori Khoury","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Khoury","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T04:35:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":43,"score":null,"hot":3381481722,"url":"https:\/\/community.smartsheet.com\/discussion\/108270\/hiding-row-comments-in-a-report-in-portfolio-workapp-project-workapp","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108270\/hiding-row-comments-in-a-report-in-portfolio-workapp-project-workapp","format":"Rich","tagIDs":[466,578,580,581,582],"lastPost":{"discussionID":108270,"commentID":388266,"name":"Re: Hiding Row Comments in a report in Portfolio Workapp\/Project Workapp","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388266#Comment_388266","dateInserted":"2023-08-01T18:07:36+00:00","insertUserID":11482,"insertUser":{"userID":11482,"name":"Lori Khoury","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Khoury","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-03T04:35:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-02T11:58:51+00:00","dateAnswered":"2023-07-30T03:51:38+00:00","acceptedAnswers":[{"commentID":387963,"body":"
- Build a Report that refer to all project sheets (as source sheets) and setup \"As current user\" filter, then embed that Report to a Dashboard (with Viewer mode setting is \"Their own perspective\" in Dashboard). The viewer will not see only data regarding to them without the comment column.<\/li>
- Build a Report that refer to all project sheets (as source sheets) and build a Dynamic View (DV) that refer to this Report (as source data) and setup :
- \"As current user\" filter in this DV for external stakeholders to see only data regarding to them. <\/li>
- Hide comment<\/li><\/ol><\/li><\/ol>
This will save your effort to build many DV for different stakeholders<\/p>
Hope that helps<\/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":["discussion","question"]},"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":466,"urlcode":"control-center","name":"Control Center"},{"tagID":578,"urlcode":"portfolio-workapp","name":"PORTFOLIO WORKAPP"},{"tagID":580,"urlcode":"workapp","name":"workapp"},{"tagID":581,"urlcode":"comments","name":"comments"},{"tagID":582,"urlcode":"global-updates","name":"global updates"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&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":631,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
