Introduction to Abstra
Microsoft SQL Server
You don't have to manage a database to have your data organized.
You can access your google spreadsheets using Abstra. Create one connector for each document.
You need to authorize access to the specific spreadsheets you need
Select the spreadsheet
Add a method for each query you want to make.
Use A1 notation for ranges
Test to see if this is working
Also you can set the first row as a header. For example you have a sheet like this:
If you check the
set first row as header
box, your result will be transformed into:
This makes it easier to use the data in
and tables like so: