Within your Virtually account, go to "Settings"

Scroll down until you see "Your Airtable Account"

Go to our sample template and create a new Airtable base and table with these exact fields as type "Single line text" except for "Session Rating" which should be a number.
​
​You'll need to create these exact fields for the export to work correctly:
​
​Attendance Data Table
- Attendee Name
- Attendee Email
- Session Date
- Attendee Join Time
- Attendee Status
- Excused
- Guest
- Session Name
- Session Tag
​
​Survey Data Table
- Attendee Name
- Attendee Email
- Session Date
- Session Name
- Session Tag
- Session Rating // NOTE: this type should be a number
- Session Comment
- Submission Date
​
​Important: Any typos or field type mismatches will also prevent the export from working correctly. Please double check for case mismatches and any misspellings.
​​

Sign into https://airtable.com/create/tokens (make sure you're logged into the same account you used to create the tables above).

Click the "create new token" button

Give the token a name that you can use to differentiate from other tokens (e.g. Virtually Auth Token)

In the "Scopes" section, select both data.records:read and data.records:write.

In the "Access" section, select the base you want your attendance and survey data to be sent to.

When all is done, you should see something like the above. Go ahead and hit "Create token".

You should see a pop-up with your token's value. Make sure to copy this so you can store it in Virtually, as Airtable won't show it again. You can also optionally store it in another safe place, like a password manager, for easy access back to it.

You should now see the new auth token in your dashboard

We'll use the new value you created in the next section.

Go to https://airtable.com/api

Sign in if you're not signed in and click on the Airtable page to which you'd like to export data.

Now copy the part of the URL which has "app" at the start, until the first forward slash ("/"). For example, if your Airtable URL is https://airtable.com/appRt3wnABCeEGVhl/tblentT1hmw2yofUs/viwbSlxRaqK2lKTqN?blocks=hide, your Base ID would be "appRt3wnABCeEGVhl".

This one's easy! Just go to the sheet you want to use and copy the title in the tab at the top. Please note that this field is case sensitive, so you must copy it exactly. For example, this would have a name of "Template":

Navigate to the "settings" tab in your Virtually admin dashboard.

Click on "Integrations" at the top.

Scroll down to the "Airtable" section in "Not connected" and click "Connect"

Paste the Personal Access Token and Base ID you obtained in the previous steps and hit "Save". (The token should start with the prefix pat and the Base ID should start with the prefix app.)

Now, click "Add" for the Attendance data and input the name of the table. In our example above, our table was named "Template" so we would add that name. Important: if you change the name of the Airtable table in the future, you must change its name in Virtually as well.

Once you have everything set up, just click "Send test data" for each table you wish to test. You should see the following toast after a few seconds: