Table of contents:

Use the top row as a header

When you create a flow with Google Sheets, Unito will look at the top row to find the fields it needs to sync. So if you named cell A3 "Description," you'd find a field called "Description" in Unito when it comes time to sync your information. That means you could map the description field in a tool like Asana or Trello to this field, and that column would be automatically populated with information pulled right out of the task descriptions in these tools.

It's a good idea to freeze the first row of your Google Sheet. Otherwise, it might get moved around when you sort your sheet, which could break your Unito flow.

Add UnitoID and Last Modified columns

The UnitoID and Last Modified fields are essential for any Unito flow involving Google Sheets. Unito will only sync information found within these two columns. In the above screenshot, that means only information between the A and E columns will be synced. If you needed to add more data to your sheet, you can absolutely create a new column, as long as it's between the UnitoID and Last Modified columns.

When you install the Unito add-on for Google Sheets, you can automatically add these columns to your sheet at the click of a button.

You can hide these columns if you want, but they do need to exist. We don't recommend hiding them, however, otherwise someone in your workspace might accidentally delete them.

Recover deleted UnitoID and Last Modified columns

Say you've deleted the UnitoID and Last Modified columns. Is your flow doomed? Not quite! Should you recreate the columns? Sure, if you want duplicated data.

Your first step should be to undo the deletion, if you can. Simply hit Ctrl+Z (or Cmd+Z if you're on a Mac). If your columns come back, congratulations, you've fixed the problem.

If a simple Undo can't bring the columns back try checking through your sheet's history. Find a version that had the columns, restore it, and you should be good to go.

This holds true not just for the columns themselves, but all data in them. If you delete a cell in either the UnitoID or Last Modified columns, you'll need to undo that change or restore a previous version of the sheet. Otherwise, the information in that row won't sync anymore.

Note: Don't lock these columns, as this will prevent Unito from making changes to them. That will prevent changes from being synced.

How to sync custom fields

When you're building a flow with Google Sheets, Unito treats everything on the Google Sheets side as a custom field. But some tools, like Trello and Asana, have their own kind of custom field, separate from regular fields. In order to sync these fields to Google Sheets in a two-way flow, the equivalent field in Google Sheets needs to be written exactly the same.

What does that mean?

Say you have a "High Priority" custom field in another tool, and you want to sync it to a specific column in Google Sheets. The top cell of that column has to be called "High Priority". Same casing, same words, same spelling.

You can make this much simpler by using Google Sheet's Data validation feature. To do this, right-click on a cell in the first row of your sheet and click on Data validation.

In the data validation menu, make sure Criteria is set to List of items. Then, you can enter the different options for your custom field, separated by a comma.

Now, when you click on that cell, you'll have to choose between one of the options you set, preventing any errors.

Did this answer your question?