OVERVIEW
UPDATE: Query Builder Now Available for Googlesheets!
IMPORTANT REMINDER
--> In Excel, ALL custom function require a "." after the =CS.FUNCTION()
--> In Googlesheets they do not so it's just =CSFUNCTION()
--> See example at bottom of this article
The query builder is a simple, pre-made template that makes it easy to quickly and automatically load any endpoint including all of its parameters and descriptions.
Googlesheets
The Query Builder template is VERY similar with a few nuanced differences
How To Use
Find the Query Builder template from the add-in global search or templates tab in the browse section
Load the template in an existing workbook or create a new workbook
Type a provider and valid endpoint for that provider, the proper parameters will automatically populate in the parameters column
1-a) Search for templates from the global search:
1-b) Search for templates from the browse section:
2-a) Select the Query Builder template:
2-b) Choose how to load the template:
⚠️ *NOTE: Googlehseets users may need to use this link instead
REMINDER - THERE IS NOT "." IN GOOGLESHEETS CUSTOM FUNCTIONS!
Cryptosheets is free to sign up and start using now. What are you waiting for?
Signing up for Cryptosheets is free --> Get crypto data in 30 seconds or less
ADDITIONAL RESOURCES
Website | WebApp | Excel | Googlesheets | Help Center | Blog | Twitter
______________________________________________________________
Tags: templates, query builder, guide, tutorial, functions, parameters, CS.QUERY, CSQUERY excel, googlesheets, crypto