--- title: "Import agenda using a synchronized sheet" description: "Learn how to import a large number of sessions and speakers into the event agenda in Meeting Application using a synchronized sheet in Google Sheets" url: https://help.meetingapplication.com/en/articles/9497450-import-agenda-using-a-synchronized-sheet collection: "Data importing" updated: 2026-10-28 language: en alternates: [pl] --- # Import agenda using a synchronized sheet Learn how to import a large number of sessions and speakers into the event agenda in Meeting Application using a synchronized sheet in Google Sheets Learn how to efficiently manage a large number of sessions, speakers, and access settings in the event agenda using a synchronized Google Sheets spreadsheet (Event Sync feature). Entering data related to the event schedule and speakers was designed not only to make it easy to upload information to the system once, but also to conveniently update it in bulk. Thanks to Event Sync, the spreadsheet works both ways – you can import data into the system as well as export the current state of the event to the sheet. ## How to start integration with the import file 1. Add the **Agenda** and **Speakers** modules to the event. If you plan to use several modules of this type, add several right away. 2. On the event modules list, click the three dots next to a module and go to edit name. Enter clear names (e.g. "Main Stage Agenda", "VIP Speakers") so it’s easier to decide which content goes to which modules. 3. In the side menu of the panel, click **Import Agenda Sessions** (Event Sync) to go to the configuration. Click the **Import Agenda Sessions** button to see a direct instruction for the next step.  ![](https://staticfiles.gleap.io/ghelparticle/Nnkwsul5vkHhDbmAILGplj26EuuQ4O15zvsFwzn8wsWKDrmGOepBDc8q1iIEBh33QJKAtecaCDS.png) ![](https://staticfiles.gleap.io/gattachments/jzMe0X5kHLDjbC6qREiHpC4i8yRmhmxArzd5zh0HehPSfg0IPfORavgJ2VQNJJ436j1NmWUaC4j.png) ## **How to connect and sync a sheet (Step by step)** The sync process has been streamlined. Now you can start your work by downloading up-to-date data from the system instead of starting from a blank page. 1. In the import window, click the **Download import template** button to open a new page with the current template. 2. On the new page, click **Make a copy**. The sheet will be saved to your Google Drive. 3. Share the copied sheet (with edit rights) to the technical address indicated in the panel, e.g. [spreadsheet-access@spreadsheetaccess-397013.iam.gserviceaccount.com](mailto:spreadsheet-access@spreadsheetaccess-397013.iam.gserviceaccount.com). 4. In the URL of the open sheet, find the part between /d/ and /edit. For example, if the link looks like this: [https://docs.google.com/spreadsheets/d/1dSo...Y494/edit](https://docs.google.com/spreadsheets/d/1dSo...Y494/edit), the part you need to copy is the string 1dSo...Y494. 5. Paste the copied ID into the **Spreadsheet ID** field in the Meeting Application panel. Enable synchronization and click **Save changes**. > **Success:** **Have you already entered any information in the admin panel? START WITH EXPORT!** Before you start entering data manually, use the **Export to sheet** button. The system will fill the sheet with the current state of the event. **Note:** Export overwrites the content of the tabs with the current data from the system. 6. Enter or edit the data in the sheet. 7. To upload the changes to the app, go back to the panel and click **Sync**. ⏱ **Automatic sync:** With the integration enabled, data between the sheet and the system syncs automatically **roughly every half an hour**. The "Sync" button lets you instantly and manually force a data fetch from the sheet. ## **Tab "Import Reports" (Reports and Validation)** Before the system uploads your data, it **checks if the sheet is correct** (whether all tabs are there and whether the column names match). If there’s a structural error in the sheet, the import is paused so that partial or incorrect data isn’t uploaded. Every operation (import and export) leaves a trace in the sheet in the **Import Reports** tab. Always check this tab after clicking sync. You’ll find a row with the date, status (success/error), and details. This is your first place to diagnose issues if you don’t see the changes on the event page. ## **How to fill in each tab in the sheet** Greyed-out fields in the sheet generally shouldn’t be edited (these are, for example, previews or system messages). Columns marked in blue are required. ### **1\. UserGroupTags (Access Groups)** Used to create and edit your own access groups (defining who can see a given session). - System groups (e.g. "All users", "Logged in users") are visible here as preview only. - **Security:** Synchronization never removes access groups from the system. Deleting a row in this tab will not delete the group in the management panel. ### **2\. SessionTags (Session Tags)**  Here you create and edit tags that describe the session format (e.g. "Lecture", "Workshop", "Q&A"). ### **3\. Agenda** The main page for managing sessions. > **Success:** 🛡 **SESSION PROTECTION:** Sync **never** removes from the system a session that participants already have seats reserved for or tickets sold – even if you accidentally delete that row from the sheet. - **session\_id** – unique session number (e.g. 1, 2, 3). Numbers can’t be repeated within the whole event. - **agenda\_component\_id** – agenda module ID. Click the cell, use the _Data Picker_ button in the top menu, pick _Components_ and select the right module. - **session\_name** / **description** – session name and description. - **day** / **start\_time** / **end\_time** – date and time formats, e.g. 2026-04-30 and 2026-04-30 14:30:00. - **place** (Location) – you choose it from the dropdown list by name (you first need to add places in the _AgendaPlaces_ tab). - **path** (Track) – you choose it from the dropdown list by name (added in _AgendaPaths_). - **group\_tags** (Access groups – formerly 'tags') – decides who can see the session. Use the _Data Picker_ to insert tags from the _UserGroupTags_ tab. **Note:** leaving this field empty means the session has no group restrictions (it’s visible publicly). - **session\_tags** – tags defining the nature of the session. Enter the names created in the _SessionTags_ tab (separated by commas). - **streaming\_link** – link to the stream starting with https://. - **agenda\_session\_children\_id** – IDs of child sessions (if you’re creating a session block). ### **4\. AgendaPlaces** Enter possible locations for sessions here (e.g. Aula, Madrid Room). You can define their name, color, and order. You’ll use them later in the Agenda tab. (Note: the system now ignores accidental spaces at the beginning or end of the name). ### **5\. AgendaPaths** Enter possible session types here (e.g. Workshops, Presentation). Just like places, you define their name, color, and order. ### **6\. Agenda Translations** Page for adding translations for available language layers (languages must be added beforehand in the management panel). - **session\_id** – session ID from the Agenda tab. - **language\_code** – language layer code (e.g. PL, EN). If the code is missing in the sheet (the "_Locales_" page), first force a manual sync. - **session\_name** – translated session name. - **description** – translated session description. ### **7\. Speakers (Prelegenci)** Add speakers here so you can assign them to sessions. People added manually in the panel will only show up here after you run an _Export_. - **speaker\_id** – unique speaker ID (e.g. 1, 2, 3). Numbers can’t repeat. - **speakers\_component\_id** – speakers module ID (use _Data Picker_). - **first\_name** / **last\_name** – speaker’s first and last name. - **order** – position on the list (1, 2, 3...). - **vip** – VIP status (forces the speaker to be shown at the very top of the speakers list). - **position** – job title. - **company** – company. - **country** – speaker’s country of origin. **You need to use ISO standard names** (e.g. type in PL instead of Poland). - **description** – speaker description / bio. - **email** / **phone** – contact details. By default this info is hidden publicly in the system, even after import (to reveal it, you need to turn on the right toggle in the speaker edit panel with their consent). - **facebook, linkedin, twitter, youtube, instagram** – social media links. - **photo\_url** – Link to a square speaker photo in JPG or PNG format (it has to be a publicly available URL link). > **Info:** Images now work both ways! After export, you'll see the image ID from the system here. To remove an image, clear the cell. If you don't change anything, the image will stay as it is. ### **8\. Joins (Connecting Speakers with Sessions)** This page lets you assign speakers to specific sessions. Columns with the prefix hint\_ are greyed out and are filled in automatically to help you find your way around the ID numbers. - **join\_id** – unique connection ID number. - **session\_id** – agenda session ID. - **hint\_session\_title** – _automatically_ shows the name of the selected session. - **speaker\_category\_id** – speaker category ID (e.g. ID for the "Moderator" role). You create categories on the _Speaker Categories_ page. - **hint\_category\_title** – _automatically_ shows the indicated category. - **speaker\_id** – speaker ID from the _Speakers_ tab. - **hint\_speaker\_last\_name** – _automatically_ shows the last name of the speaker you’re assigning. - **speaker\_order\_in\_category** – the order in which the speaker will appear in a given category in the session (e.g. 1, 2, 3). If there’s only one, enter 1. ### **9\. Speaker Translations** Adding translations of positions and speaker descriptions. - **speaker\_id** – speaker ID. - **language\_code** – language code (ISO). - **position** – translated position. - **description** – translated description (bio). ### **10\. Speaker Categories** Generating speaker categories (roles) (e.g. Speaker, Moderator, Partner). They are necessary to assign a speaker in the _Joins_ tab. - **speaker\_category\_id** – unique category number. - **agenda\_component\_id** – agenda module (use _Data Picker_). - **hint\_component\_name** – _automatically_ displays the module name. - **category\_name** – category name (e.g. "Speaker"). - **order** – category hierarchy (e.g. Moderator = 1, Speaker = 2). Decides which category is displayed higher. - **visible\_on\_list** – whether the content of the category should already be visible on the general list of all sessions (TRUE/FALSE). - **visible\_in\_details** – whether the content should be visible after opening the session details. ### **11\. Speaker Category Translations** Translations of the category names themselves (e.g. changing from "Prelegent" to "Speaker" for the EN layer). - **speaker\_category\_id** – category ID from the previous tab. - **hint\_category\_name** – _automatically_ displays the translated name. - **language\_code** – language code. - **category\_name** – translated category name. **Have a great event with Meeting Application!**