Pulling Data from DataBlend

Users can easily access the DataBlend Add-on from any Google Sheet. Users can run workflows and get data, get data from streams, get data from queries using the DataBlend Add-on.

Run Workflows and Get Data

Open desired Google Sheet.
Users will access the DataBlend Add-on by selecting the Extensions menu at the top of the page. Here users will see DataBlend Add-on at the bottom of the Extension drop-down menu.
Select Run Workflow and Get Data from the DataBlend menu.
The DataBlend – Workflows side menu will appear on the right of the screen.
Select the group from which to collect data in the Groups section.
Select the workflow to run from the Workflows drop-down menu.
Select the collector from the Collectors drop-down menu.
Select the Stream Type. Latest and Specific date and times are available for collection.
Collections will be available to select from if a specific stream type is selected. However, if the latest stream type option is selected, the collections field is now locked to prevent the wrong collection date from being selected.
Select the Collection Items from the drop-down menu.
Select desired fields from the field options. Drag and drop the fields into the Selected Fields section.
Click the Fill spreadsheet with data button. Please note, clicking the Fill spreadsheet with data button will re-populate the fields within the Google Sheet.

Get Data from Streams

Users can collect Stream data from DataBlend regardless of the association to a collector, query, or workflow.

Open desired Google Sheet.
Users will access the DataBlend Add-on by selecting the Extensions menu at the top of the page. Here users will see DataBlend Add-on at the bottom of the Extension drop-down menu.
Select Get Data from Streams.
The DataBlend – Streams side menu will appear on the right of the screen.
Select the Group.
Select the Data Source from the drop-down menu. Please note, all names within Google Sheets are synchronous with DataBlend names. The name of a Data Source within Google Sheets will be the same name as the Data Source within DataBlend.
Select the associated Schema from the drop-down menu.
Select the stream from the drop-down menu. Streams may be chosen as a specific date and time or as the latest available stream. Please note, selection of the latest stream will update as more streams are added.
Select desired fields from the field options. Drag and drop the fields into the Selected Fields section.
Click the Fill spreadsheet with data button. Please note, clicking the Fill spreadsheet with data button will re-populate the fields within the Google Sheet.

Get Data from Queries

Open desired Google Sheet.
Users will access the DataBlend Add-on by selecting the Extensions menu at the top of the page. Here users will see DataBlend Add-on at the bottom of the Extension drop-down menu.
The DataBlend – Queries side menu will appear on the right of the screen.
Select the group from which to collect data in the Groups section.
Select the query to run from the Queries drop-down menu.
Select the Query execution type. Latest and specific date and times are available for query results.
Query results will be available to select from if a specific stream type is selected
Select desired fields from the field options. Drag and drop the fields into the Selected Fields section.
Click the Fill spreadsheet with data button. Please note, clicking the Fill spreadsheet with data button will re-populate the fields within the Google Sheet.