In this tutorial, we'll show how you can integrate Google sheets into your monday.com boards using an app called Data Importer.
Install the Data Importer app for monday.com
-
You can install the Data Importer app from the monday.com app marketplace.
-
Once you’ve installed the app, you can return back to your board, then press then press the add view button.
-
Select the ‘Board views’ dropdown, press ‘Apps’ then select the ‘Data Importer’ app. This will load a new board view with the Data Importer app.
Connect to your Google Account
1. Select the Google Analytics application from the dropdown list, then press the blue Connect button.
2. A new tab will open up that will allow you to connect your account with Google. Choose the Google account that you want to authenticate for. You can always connect to a different account later if you need to.
Set-up your Google Sheets Integration
1. Navigate to your Google Sheet. Ensure that the header names are in the first row.
2. Copy the url from the
3. Paste the url into the 'Google Sheets Url field'.
4. Select the sheet name that you want to import data from. In this case it is just Sheet1.
5. If enabled, the First Column as Item Name toggle will bring the first column in the sheet as the first column (Item Name) in your monday.com board. Otherwise, the Item Name will just be a row number.
Press Run and View Your Data
-
Once you’ve filled out all the required fields, press the blue Run button.
-
When the run is complete, press the button to view the board. You’ll see a new board created with the board name you entered which will contain your imported sheet.
Automatically sync your Google Sheet with your monday.com board
Now that you know how to import Google Sheets into monday.com, you can automate your imports by using Data Importer's scheduler. This means your boards will automatically refresh with the latest data, even when you're offline or not signed into monday.com
You can customise the schedule by frequency, days of import, time and timezone.
You can view all your scheduled imports in one table from all of your applications.
