Example Configurations and Use Cases

Exporting to a new file in Google Drive

For integrations ending "export to the same file every time".

1. Add a New Integration

   • Select when and how often the board will be exported.
   • Enter a file name, that will be created in Google Drive.

2. Export Process

   • The application will create a new file.
   • Subsequent exports will update this file every time.

For integrations ending "create a new file every time".

1. Add a New Integration

   • Select when and how often the board will be exported.
   • Enter a file name.
   • Enter Google Drive folder URL.

2. Export Process

   • The integration will create a new file for each export.
   • For frequent exports, ensure they are scheduled at least 1 hour apart to guarantee each export generates a separate file.

Exporting to the same file multiple times a day

To export to the same file multiple times a day, follow these steps:

1. Set Up the Initial Integration

   • Use one of the templates provided below to set up the first integration.
   • Configure it to export data once a day at a specified time.

2. Wait for the First Export

   • Allow the initial export to occur at the configured time.

3. Add Additional Integrations:

   • Use one of the templates provided below to add more integrations.

   • Point each new integration to the Google Drive file URL created in the previous step.

   • Schedule each additional integration at different times to achieve the desired export frequency.

     

By setting up multiple integrations with staggered schedules, you can export data to the same file multiple times a day.

Exporting to the existing file

Application can export to the existing file that was previously created by the application. To export to the existing file, follow these steps:

• Use one of the templates provided below to add additional integrations.

• Point each new integration to the desired Google Drive file URL, that was previously created by the application.

• Schedule each additional integration at different times to achieve the desired export frequency.

  

Exporting to a specific folder

For integrations ending "export to the same file every time":

• The file can be moved in Google Drive, and the integration will continue exporting to that file.

For integrations ending: "create a new file every time".

To export to a specific folder, follow these steps:

1. Add a New Integration

• Enter the file name,
• Enter Google Drive folder URL link to the desired location.

By following these steps, you can ensure that each new file created by the integration is saved in the specified folder.

Exporting boards with many columns (Over 100)

If you have a board with an extensive number of columns, exceeding 100, it is recommended to export only the specific columns you require. However, if you need assistance exporting all columns, please don't hesitate to reach out to us for support.

Here are example steps to export the "Status" and "Date" columns:

1. Open your monday board.

   

2. Utilize the following integration:

   

3. To specify the columns you want to export, provide a list of their names. You can separate the column names by commas or write each name on a separate line:

   

   

4. Once the integration runs, it will generate a Google Drive document containing only the "Status" and "Date" columns. The Group and Item Name columns are always included:

   

Combine data from multiple boards in one Google Sheet file

In this example we will combine data from two boards, boards A and B in the same Google Sheet document. Data from Board A will be in the first tab, and data from Board B will be in the second tab.

Steps to follow:

• Add integration to export Board A to file A (export to the same file every time)
• Add integration to export Board B to file B (export to the same file every time)
• Create a new Google Sheets file, add two tabs and import data from file A and file B with =IMPORTRANGE function.