For submitted forms and documents uploaded via forms, these can be set to automatically populate in a Google Drive folder of your choosing.

You will need to either choose an existing folder, and create a new one.

Whether it's a new or existing folder, this is where your live sheets will be created.

Ensure that the folder is shared with automation@theticketsellers.co.uk as an Editor.

Share > add automation@theticketsellers.co.uk and select Editor

Once you have selected + Create live sheet integration you will see you have a few options.

You can either choose:

All form types

or

Specific form types

If you select All form types then for all forms with submissions, the completed form data will be automatically pulled into a google live sheet - a spreadsheet which is automatically updated at regular intervals.

If you select Specific form types, then proceed to select which ones. You can choose one specific form or several. You can add additional forms at a later date.

Here you can select how often your live sheet is updated.

Please note that the frequency set is when the system will start checking for updates. If lots of forms have been submitted since the last update then it may take a few minutes for all new answers to pull through.

If you choose Every 4 hours, it will update every 4 hours, starting from when you select Create.

Once you select Daily or Weekly, you will have further options for time of day and day of the week that syncing takes place.

Daily example:

Weekly example:

This is how you tell Eventree where you'd like it to create your new live sheet. Once you add the Folder ID, it will create a new spreadsheet within that folder, which will automatically populate with form answers.

This is how you tell Eventree where you'd like it to download your files into.

You can copy and paste the whole folder link into this field and it will extract the folder ID for you when you select Create.

It will then automatically create a live sheet within your selected folder, on the hour after you have set up your syncing. So, if you select Create at 9.30am it will create and populate your live sheet at 10am.

If you have chosen Every 4 hours, it will then update every 4 hours after that point.

Once you have selected the options you want, remember to select Create.

For every Syncing task you set up you will see it listed on that page now, along with the date that it last updated (synced).

This will now continue to update your live sheet at the selected frequency up until 24hrs after your event ends (based on the event dates set in your Eventree portal).

Once it is set up, you can quickly click through to View the destination folder and see where your live sheet has been created by selecting the dropdown.

If at any point you wish to cancel this task as well, you can simply delete it.

This won't delete the live sheet, it will just stop any new updates from being synced across.

Once created, there are a few things you can change if you select Edit.

You can add more Forms to this task and you can also change the frequency that the documents get updated.

If you would like to also set up syncing form documents, see our other help articles.