# Documentation

3. Provide the ID of the root folder.

• All sheets documents in that folder and child folders will be pulled.

• You can find the ID by clicking on the folder where your sheets reside and using the last part of the URL, such as https://drive.google.com/drive/folders/0B2kqcwp2ycGZanhSR3JmREw5VTV

4. Optional Filters to limit the pulled files, based on Google's filter documentation.

• Note that we assume trashed=false filter.

5. Define which files to import:

1. All files will pull all the data from your folders (for a given prefix, if defined above), and will continue to do so forever.

2. A date span pulls files written between the given dates, inclusive. If you select the date span option and don't specify dates, the input will only pull files written after the input was created.

Keep the mapping mode to the default of OneClick if you'd like Alooma to automatically map the Google Sheets spreadsheet events directly to your data destination. Otherwise, they'll have to be mapped manually from the Mapper screen.