In Sheetgo, a source is the first step in building any type of automations. It is where data is extracted and then processed, transformed, and transferred to a destination. Selecting the right source is crucial as it determines the initial set of data that will be used in your automations.

Here, we will explore the available source options in Sheetgo and what can be achieved with each type.

Format: Google Sheets, Excel, CSV, or TSV files

Capabilities: Selecting single or multiple spreadsheets as a source, you can easily extract data from any spreadsheet stored in cloud services like Google Drive, OneDrive, or SharePoint. This allows for the integration of data from various systems and applications, maintaining a consistent data structure and ensuring your workflows are always working with the latest data.

Format: Folders containing spreadsheet files located on Google Drive, SharePoint, or OneDrive.

Capabilities: Using a folder as a source allows you to manage and process data from multiple files stored within a folder. This is particularly useful for scenarios where you regularly add new files to a folder and want to include all of them in your workflow automatically. It streamlines data management and ensures that all relevant files are considered in your data processing tasks, providing flexibility and scalability.

Format: BigQuery

Capabilities: Using a database as a source allows you to extract large volumes of data for detailed analysis and reporting. This is ideal for businesses that need to analyze big data and run complex queries efficiently. Databases provide powerful insights and data-driven decision-making capabilities, enabling you to handle large datasets seamlessly within your workflows.

Format: JSON API

Capabilities: Using an API as a source allows you to integrate data from a wide range of external applications and services into your Sheetgo workflows. This is perfect for automating data collection from web services, ensuring dynamic and up-to-date data integration. It enables your workflows to include the latest information from different online platforms, enhancing the relevance and accuracy of your data processes.

Understanding the different source options in Sheetgo and their capabilities allows you to build more efficient and effective data workflows. By selecting the appropriate source, you can ensure that your data is accurately extracted and processed, leading to better insights and streamlined operations.