monday.com

Entity

• Select the entity object that you need to post to

Source Sheet

• Choose the sheet that contains post records.

• Enter the Start at cell value 

(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)

• Select the Status column

• If status column is not there, simply click the +button to add the status header on your sheet(A status column will be created in Spreadsheet)

• Select the Result column

• If result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in Spreadsheet)

• Click on intelligent mapping to map the fields automatically.

• Click on the "+" icon to add new mapping.

Mapping

• After selecting the entity it will ask for intelligent mapping 

• If you need to do intelligent mapping click on yes

• Intelligent mapping will map the matching fields automatically

• You can do manual mapping by selecting Column drop down

• You can delete the field by click on delete icon on top of each filed map

• You can't delete mandatory* fields .

• The post service supports only the following column types

1. Text

2. Numbers

3. Status

4. People

5. Date

6. Checkbox

• Click on execute will ask for confirmation.

• Click save to save the service.

• It will show number of records ready to post.

• Click post now to post the records on monday.com.

• It will show the count of number of records posted successfully and failed to post.

• Choose the spreadsheet to store data.

• Select the required cell value.

• Select the Status column

• If the status column is not there, simply click the +button to add the status header on your sheet(A status column will be created in the Spreadsheet)

• Select the Result column

• If the result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in the Spreadsheet)

Sample Output

• The Status column in the Google Sheets shows the status of the data.

• The newly updated data will be marked as Synced Successfully.

• The old data that already exists will be marked as Already Synchronized.

• Select the sheet to store the output.

• Select the Status column

• If the status column is not there, simply click the +button to add the status header on your sheet(A status column will be created in the Spreadsheet)

• Select the Result column

• If the result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in the Spreadsheet)