How to Export Wrike Tasks to Google Sheets | Unito 2-Way Sync
Wrike Google Sheets Two Way Sync
How to Export Wrike Tasks to Google Sheets
Wrike Google Sheets Two Way Sync

How to Export Wrike Tasks to Google Sheets

There are countless reasons why you might want to export the details of your Wrike tasks into Google Sheets. Whatever the reason, you’ve come to the right place. This guide will show you how to automatically populate a spreadsheet with specific fields from your tasks in Wrike. This can be used for reporting, manipulating data with the flexibility of a spreadsheet, sharing specific details on project progress with stakeholders, or as you’ll see in our demo: getting a quick overview of your team’s time off requests.

If you’re new to Unito, you can check out our integration overview for Wrike + Google Sheets before coming back to connect your tools. The demo below is just one of many use cases for this Unito flow, which should help give you an idea of how 2-way automation can change the way you work for the better. We also have a similar guide for guide for Microsoft Excel users who want to power their reporting workflows with a 2-way, self-serve, automation.

In this guide, you’ll learn how to:

  • Set up a spreadsheet based on Wrike task information.
  • Turn the fields (details) of Wrike tasks into rows in Google Sheets.
  • Set up a two-way sync between your fields so that any changes in Wrike or your spreadsheet will automatically appear in the other.

Here’s what our synced spreadsheet and monday.com board looks like:

Wrike synced to Google Sheets with Unito 2-Way
In this example we’ve highlighted a few of the fields in Wrike that appear in our Google Sheet so you can get a better sense of what to expect from Unito. The fields (details) of each selected Wrike task populate the columns of our spreadsheet.

Put simply, your Google Sheets rows represent each Wrike task, while the columns represent the various fields (e.g., title, description, assignee, dates, etc.).

So it’s important to prepare your spreadsheet in advance with those fields in mind. It can help to name each cell in the first row something that intuitively matches with those fields.

Why sync Wrike to Google Sheets with Unito?

Drafting reports with an automation platform saves time and cuts down the risk of human error. Unito essentially takes care of all that copy-pasting for you so that you can focus more on high-skill tasks and less on redundant data entry.

Wrike is a superb project management tool for any industry or role, but sometimes you just need facts or figures in a comprehensive spreadsheet. Perhaps your boss doesn’t use Wrike, maybe you want to share a few figures with another team, or you just prefer the classic look and feel of Google Sheets.

So you have two choices: copy paste all the key details from your Wrike folders to a spreadsheet, or connect them to an automation platform with two-way sync, such as Unito. In this context, we’ll be looking at a personal time off (PTO) report, but you can create a Unito flow to sync any kind of Wrike task and folder with Google Sheets to share key data.

Before we build a report in Google Sheets synced with Wrike:

  • Install the Unito add-on for Google Sheets. This walkthrough will show you how, or you can follow that link. 
  • Keep in mind that Unito can only sync text and number fields from Wrike to your spreadsheet. Check out our integration overviews of Wrike and Google Sheets to review their capabilities and limitations.

Create a header row in Google Sheets

Go to docs.google.com and open up your spreadsheet. Make sure each column in the first row is clearly labelled with whatever titles you want to map to or from Wrike. If you don’t know how to categorize the data you want synced, you can start with this Google Sheets template.

Here is an example of a header row. You’ll need to label the first and last columns of your sheet: “UnitoID” and “Last Modified”. The Unito extension does this automatically, or you can create the titles manually.

Note: Make sure your columns are where you want them to be once your tasks begin syncing to Google Sheets. If you try to move columns around afterwards, you may encounter errors.

Install the Unito add-on to your Google Workspace

Now, click Extensions, then Add-ons, and select Get add-ons. Search for “Unito for Google Sheets” and add it to your workspace by following the on-screen instructions.

Unito Google Sheets Add-On
You can find more detailed steps on this process here.

Step 1: Connect Wrike and Google Sheets to Unito

  1. Now you can either go to the Unito App and click +Create Flow or continue from your Wrike workspace once you’ve added and authorized the WrikeSync add-on.
  2. Click Start Here to connect your tools.
  3. Select +Add a tool to this flow in either column and connect Wrike. Then click +Choose account to specify the Wrike account you want to use.
  4. Pick the Wrike project you want to connect to Unito.
  5. Repeat steps 3 and 4 to connect Google Sheets with Unito.
  6. Click Confirm.
Connect monday.com and Google Sheets with Unito

Step 2: Set a flow direction between Wrike and Google Sheets

Flow direction determines how new tasks or rows are created by Unito. So with a two-way sync at this stage, adding new rows to Google Sheets will create a matching item in Wrike, and vice versa. Since we’re building a report in a spreadsheet, we’ll choose a one-way sync from Wrike to Google Sheets.

Set a flow direction between monday.com and Google Sheets

Note: Later, you’ll be able to add field mappings to determine which fields will be kept updated in both tools — regardless of the flow direction you set here.

Select Confirm when you’ve chosen a flow direction.

Step 3: Set rules to filter data between Wrike and Google Sheets

This is where you can set up conditions to filter out Wrike tasks that you don’t want to appear in Google Sheets. If you don’t set any rules, then all items in your chosen Wrike folder will appear in Google Sheets. If that’s what you want, simply hit confirm and proceed.

Otherwise, Add a new trigger to begin setting up your rules. There can be some variability here, depending on your particular setup.

Set rules to filter data between Wrike and Google Sheets
In our demo we created a custom field in Wrike called PTO Hours, which we’ll use as our filter to populate the PTO spreadsheet. In this case if a task doesn’t have PTO hours filled in, it won’t appear in our spreadsheet.

Rules can filter data using several fields in Wrike though we recommend choosing status or priority.
You can learn more about setting up rules here.

Step 4: Customize field mappings to sync rows between Wrike and Google Sheets

Fields represent the details of your spreadsheet rows and Wrike tasks. Since you’re sending field data to a spreadsheet, you’ll only be able to sync numbers or text fields.

Before you can dive in, you have to tell Unito whether or not to try auto-mapping fields. This feature works best when fields have the same name in both tools so that Unito can easily recognize them. Since we’re working in a spreadsheet though, you’ll have to select start mapping manually.

A screenshot of the first step of Unito's field mapping process: picking auto-map or start from scratch.
Since you’ll be naming every field in Google Sheets, you must select Start mapping manually.

On the next screen, select +Add mapping, then Select a field in both bases to pair the fields together. Here’s a simplified version of our Wrike to Google Sheets field mappings

Customize field mappings to sync rows between Wrike and Google Sheets
We named all of our fields in Wrike and Google Sheets similarly to avoid confusion. PTO Hours is our custom field in Wrike.

And here’s what this set of field mappings will look like after syncing with Unito:

Wrike Google Sheets synced

Click Confirm when you’re satisfied with your field mappings.

Step 5: Save, close, and launch your workflow!

And that’s it! You’ve just built a flow between Wrike and Google Sheets. Congratulations!

If you followed the steps above, your flow ill now:

  • Automatically create new Google Sheets rows based on specific Wrike tasks.
  • Keep your spreadsheet and board updated in real-time.

If you have any questions, please don’t hesitate to reach out and let us know.

What’s next after setting up your Wrike-Google Sheets integration?

If you want to know what else you can do with Unito, here’s some inspiration to help you power up your workflows: