Get Started
Introduction
Welcome to Viasheets documentation!
Viasheets lets you connect data sources directly to Google Sheets so that you and your team can get live updates immediately!
Sources
Sources are the channels we use to pull data from, whether it’s your bank data, Stripe, Employment systems, Google Anaytics, Instagram, etc. A source is any system that we’re connected to that you can pull data directly from. Sources are configured from the Viasheets dashboard meaning that they can be added or deleted at any time.Queries
Queries serve as the foundation of Viasheets, allowing you to extract data directly into Google Sheets. A query empowers you to choose the specific data you wish to extract from a source and seamlessly integrate it into a spreadsheet. After you have crafted and executed a query, you will have the opportunity to save it, allowing you to rerun the query at a later time.Create a Query
Customize your docs to your company’s colors and brands
View & Run Saved Queries
Automatically generate endpoints from an OpenAPI spec
Templates
Templates are pre-designed spreadsheets that enable you to quickly initiate your work. Following the connection of your sources, configure the queries and execute them in the designated sections within our templates. Upon completion, you will gain access to the evaluations embedded within each template.Templates
Get started quickly with a template from Viasheets
FAQ
Where is my data stored?
Where is my data stored?
We do not retain any of your data. Upon connecting to a source, we refrain from extracting any data from that source.Instead, when you opt to import data into a spreadsheet, we save a query that informs us of your desired data retrieval. After your query executes, we incorporate the data directly into your spreadsheet, without retaining any information within our systems.
How can I establish a connection to a source that is not listed?
How can I establish a connection to a source that is not listed?
Want a source that we don’t have yet? Send us an email at [email protected] and we’ll add it in for you :)
How do you prevent data from being added twice to a spreadsheet?
How do you prevent data from being added twice to a spreadsheet?
At Viasheets, we employ cursors, which serve as our internal references to the IDs extracted from your last data row. We utilize these cursors as reference points to ensure that no duplicate data is appended to your spreadsheet.