Wrike & Google Sheets

Hi,

 

How can I export a Wrike report to a Google sheet and set it up so it will automatically refresh weekly?

 

Thanks,
Conor

 

Upvote 19
19 Kommentare
Spot On Innovative Approach Stellar Advice
Avatar
Stephanie Westbrook

Hi Conor, we have an option to export to Excel, but not directly to Google Sheets. I know it's not what you're looking for but right now one thing you could do is export to Excel, and then copy/paste the data to Google Sheets. In terms of automatic pushes from Wrike to Excel, we don't have that, but you could potentially set up tasks to remind you to export data. 

I'm wondering if we can build a Report (within Wrike) to show the information you need? The data there would automatically refresh and you can schedule Report reminders to appear in your Inbox. To know if this is a potential option, could tell me a little more about the data you need to export and why? 

If you like, we can also move this post to our Product Feedback section so that others can +1 the request?

Stephanie Westbrook Community Team at Wrike Wrike Product Manager Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

Stephanie Westbrook Wrike Team member Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I'm looking to actually do the same thing.  I need to send a weekly report to another team member who does not use Wrike.  It would be beneficial to utilize a weekly report to be pushed out or sent as an Excel Spreadsheet

or Google Sheet.

4
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Dear WRIKE Team, 

I'm also wondering if the export data from WRIKE to GSHEET / GSLIDE feature can be added to the WRIKE. We are working on linking our performance from WRIKE to a report in GSHEET, it would have been great if there was a way to make a report and directly link to a dashboard in GSHEET.  (We don't want the option of exporting it in excel and then pasting it onto GSHEET, etc )

please let me know if you are currently working on it or do we look for another alternative. 

Regards,
Sam

2
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi, we are moving to Google Sheets, instead Excel, and is really necessary to have this feature, is in the pipeline? 

If yes when?

 

Best Regards

António José

3
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Any new concerning this subjet.

It´s crucial to my enterprise have this feature.

 

Thks

António José

2
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Upvoting this!!

We have a huge team of marketing & various "requesters" that don't have licenses (due to many factors, but seeing our internal team comments is the biggest one we want to keep locked away!)

 

I'd love to be able to share a list with our marketing team that they could filter to see where their jobs are up to without it being manual, we're currently handling 200-500 jobs per day in the team so any way to reduce the "can I see where this job is up to" messages to our traffic managers would be a huge help and free up quite a bit of our time.

 

Thanks
Holly

2
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Also looking for this feature!

2
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

@Everyone  Hey, thanks for sharing your use-cases here and commenting. Currently there's no update for this feature suggestion, but I'll make sure to get back to you of I have news. 

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Thank you! This would be a great feature! Most of the team status reports I do are linked to Google documents that I can automatically update my status report from them.  With my Wrike gantt chart, it is a whole process to print the PDF, save it, open it back up and then I snip a pic of it. 

It's not very user friendly.

thanks!

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Late to the party here, but this may help some people.

We're using an integration service that supports both platforms successfully to automate our sprint reporting.  https://www.integrationfox.com/wrike-to-google-sheets-integration/  (there is a caveat though,  this is a paid tool)

Dave

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I would LOVE to be able to export some subset of the Wrike table view for a specific project or folder to Google Sheets automatically!

My use case is mainly that I want to be able to hook up ticket status to product strategy diagrams in LucidChart!  (So a direct LucidChart data source integration would also work as an alternative)

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hey Joe Marty, thanks for adding your use case and interest in this here, we've passed this on to the team 👍

If we have any news/updates to share here, we'll be sure to update the thread. 

Elaine Community Team at Wrike Wrike Product Manager Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

Elaine Wrike Team member Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi all, was wrestling with this again and came across this Google Sheets add-on for API Connector from Mixed Analytics: https://gsuite.google.com/marketplace/app/api_connector/95804724197

Did a quick test using Wrike's API (built out the settings using Postman) and was able to pull in data to Google Sheets. Next, I need to refine the API request and then start working formatting magic in Google Sheets but seems promising. Seems pretty robust if you pay for the upgrade but even with the free tier, it should allow me to wrap up a few reports.

Thought to share in case its helpful to anyone.

2
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Yep, this would be a really helpful feature. My team is currently using a google form to receive business requests from other teams we support. The form submissions populate a google sheet. We would very much like to be able to connect this google sheet to Wrike so that we can have new tasks added onto our board as our google form submissions come in.

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Welcome to the Community Jacob Lyman, and thank you for letting us know your feedback! 

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hey Wrike! This would be HUGE! Especially if we can pull in timesheets with the workload to track if the workload is matching the time being spent on projects! 

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi Trevor Krantz, welcome to the Community 🙂

Thank you for adding your feedback on this. We've shared it with the Product team and we'll let you know if there's any news to share in relation to suggestion 👍

Elaine Community Team at Wrike Wrike Product Manager Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

Elaine Wrike Team member Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Also adding to this thread.  We use Google Sheets primarily so it would be really helpful to not have to engineer this solution myself and have Wrike directly integrate with Gsheets.

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hello Janaya Fix, welcome to the Community 👋🏻

Thanks for sharing your use case and adding your support here! Please be sure to upvote the original post by clicking on the heart icon if you haven't yet. Here is a useful article explaining what happens after we receive Product feedback 🖊

 

Cansu Community Team at Wrike Wrike Product Manager Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

Cansu Wrike Team member Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

0
Aktionen für Kommentare Permalink

Folllowing List for Post: Wrike & Google Sheets
[this list is visible for admins and agents only]

Nach oben
Didn’t find what you were looking for? Write new post