Alooma can read and replicate data from your Google Sheets spreadsheets. This allows you to, for example, merge arbitrary data from Google Sheets with client usage data in your data warehouse.
Add your Google Sheets input from Alooma's plumbing screen
Click the button to authenticate with your Google credentials
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
Optional Filters to limit the pulled files, based on Google's filter documentation.
Note that we assume
Define which files to import:
All files will pull all the data from your folders (for a given prefix, if defined above), and will continue to do so forever.
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 target data warehouse. Otherwise, they'll have to be mapped manually from the Mapper screen.
That's it! You're ready to import your data from Google Sheets into Alooma!