[Status: Investigating ๐Ÿ•ต๏ธ] Automated Report Exports

Today, we are subscribed to scheduled report notifications, however, we would love to see this data compared day over day, week over week and month over month... so we have to log in and export the data at the same time every day, week or month respectively. It would be great if we could subscribe to receive the exported Excel data instead of just a Wrike notification. This would eliminate the need for manual work and would cause less human error caused by busy schedules and various users.

Upvote 85
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
25 comments

I would like to add to the above request for Automated Excel Report Exports. In addition to the above, I would like:

  • Ability to schedule the exporting of Report in Excel format multiple times in 1 day.
  • Ability to specify the exact name and location that the resulting Report should be saved on the computer system (not just emailed or put into download folder).
  • Option to have the Report automatically export when data captured in that Report change.

Why do I ask for these things? I am trying to set up a calendar for everyone in my company to be able to view (not edit). Since Smart Calendars are only available from within Wrike (and then only to Regular Users and External Users, not Collaborators), I need to have a way for non-Wrike users to be able to view the Calendar data (start/end dates at the Project level). There is a way to do this manually by exporting a Wrike Report in Excel and then having my calendar application read it, but this is a very manual process now (so will not work for me). To automate it, I need to be able to schedule the Report for multiple times per day (better yet, whenever data changes), and specify the exact filename and location for the resulting Excel Report file that is exported, and have the Report write over the file data.ย 

Thanks for listening.

8
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hi,

I would also like to add to the above request.

Ideally, it'd be great to be able to connect to Wrike via PowerShell (or equivalent) and be able to use a command to export a particular report to CSV.

Thanks in advance,

Chris

5
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

I'd like to export a report to a folder at a regular time interval all well or call something to generate the file.ย  I wrote an R script that summarizes the data and would love to automate as much as possible.

3
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hi Team,

Do we have an update on this please? Having to set reminders to export data on certain days and times is frustrating. It would be far easier if Wrike automatically exported the data at a scheduled time for us!

Cheers

mdr

2
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hello everyone, thanks a lot for your continued feedback here!

This suggestion is definitely on the team's radar and they consider adding this to the longer-term roadmap.ย 

mdr

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

2
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

I agree with the requests above.ย  Many of our conversations with the Wrike team about reporting resulted in being told that pivots and other complex reports belong more in the Excel/Spreadsheet realm (ie export and manipulate).ย  I would really like to see a method to automate an export of a folder, report, or even complete dataset instead of having to manually copy daily updates into our spreadsheet framework.ย  I've come to grips with using the spreadsheets, but we just need a better way to get the data there, since no API's exist that can fulfil this need.

3
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Ideally as well, we would have a way to automate the report exports via various methods, not just email. Example, Dropbox, Google Drive, OneDrive, and more complex but beneficial possibly, directly to an AWS S3 bucket.ย  Also, being able to export as different file types, not just .xls/.xlsx, but also .txt or other delimited file types (specifically .csv for example).ย ย 

2
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Thank you for sharing your feedback Tom Pipes, Bryant Hafemeyer! Please make sure to upvote (= "like") Laura's initial suggestion above - that's how we count the votesย ๐Ÿ‘ More details in this post.ย 

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

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Is there any update to this?ย  Would be super helpful to my team.

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Is there an update? This is a crucial enhancement to help automate the processย 

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
Avatar
Cansu

Hi Adrian Landis and Mehdi Boudra, thank you both for checking in here. The team has plans to review this suggestion within this year, if we have any updates, we'll make sure to let you know here๐Ÿ‘๐Ÿผ

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Any updates on this request please?

3
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hi Luke Etherington, welcome to the Community ๐Ÿ‘‹

I don't have an update at the moment as this isn't on the team's immediate plans, but this thread will soon reach the 60 votes threshold and we'll be adding a Product status here ๐Ÿ‘ย 

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
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

This could be very helpful indeed!

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hi! Is there any update? Would love to use this feature!

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

This would be a gamechanger if you could add it.ย  Any feedback on a possible timeline?

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Yes, this would be great to have. I've been wanting it for years but have a more immediate need and wondering if now it's exceeded 60 upvotes if it's been added to the development roadmap

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hi folks, apologies for the late reply here! We were checking with our team internally as this post has reached the 60 upvotes threshold.ย 

Our team is currently researching sharing capabilities for reports, and the "Investigating" status reflects that ๐Ÿ‘ We will let you know how this research goes when we have an update ๐Ÿ™Œ

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
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Also looking for this capability.ย  We need to be able to communicate status to our customers.ย  It is frustrating and cumbersome to do this manually.ย  I would love to be able to automatically get updated reports in an excel/google sheets format on a weekly basis.

ย 

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Welcome to the Community Devan Brua ๐Ÿ‘‹ Thank you for supporting this suggestion! We'll let you know when we have an update here ๐Ÿ‘

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
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Would indeed be very usefull to have Wrike automatically issue excel format reports on a periodic (or event) basis. This would allow us to make our reporting much simpler.

ย 

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
Avatar
Juan

Thank you for your comment Filip Lรฉonard, I've passed your feedback on to our Product Team ๐Ÿ‘

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hi, could we have an update on this, it has been more than a year @... and Lisa. Would it be possible to build an API that pulls the data from our space also? Who to reach out to if so to have the API access?

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

I second Victorya's follow-up. Not being able to automate data extraction and ingestion is a major shortcoming in the Wrike product.ย 

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hi folks, thanks for bumping this thread!ย 

We don't currently have updates for this idea, but please rest assured we've shared your feedback with the respective team at Wrike.ย 

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
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Folllowing List for Post: [Status: Investigating ๐Ÿ•ต๏ธ] Automated Report Exports
[this list is visible for admins and agents only]

Top
Didnโ€™t find what you were looking for? Write new post