IT and Development
SheetRocks
24 min
sheet rocks is an api service that lets you turn google sheets into a restful database integrating with make com enables users to automate reading, writing, and updating google sheets data directly via api in their workflows this is ai generated content based on official sheetrocks documentation the content may contain mistakes please verify important information if you have questions on vendor documentation, contact https //sheet rocks directly requirements to use the sheetrocks app in make, you must have an active account and a bearerauth token, https //sheet rocks for subscription, refer to the https //sheet rocks connect sheetrocks and {{product name}} to get started, you must first create a connection between sheetrocks and {{product name}} , allowing the two services to communicate obtain your api key in your sheetrocks account create the connection in make obtain your api key in your sheetrocks account before you create the connection in {{product name}} , you should first obtain your api key in your sheetrocks account to obtain your api key navigate to the api keys section from the account menu copy the api key displayed on the screen you will use this value while creating a connection in {{product name}} because the ui might have changed, the steps you see on your screen might be different, https //get sheet rocks/support/api keys create the connection in {{product name}} https //www make com/en/register , add the sheetrocks module to your {{scenario singular lowercase}} , and click create a connection if you add a module with an instant tag, click create a webhook , then create a connection optional in the connection name field, enter a name for the connection enter the authentication credentials you copied from your sheetrocks account or follow the on screen instructions to create the connection for detailed information on connecting an application, see docid\ so88fm6pkt0g adkddfzz page sheetrocks modules after connecting to the sheetrocks app, you can choose from a list of available modules to build your {{scenario plural lowercase}} add multiple rows inserts several new rows of data at the bottom of the selected spreadsheet add a row inserts a new row with your specified data at the bottom of the selected spreadsheet add a sheet creates a new worksheet within an existing workbook clear formatting in range removes all text and cell formatting from the specified range of cells clear values in range removes all data from the specified cell range, leaving the cells empty create a new permission rule creates a new rule that defines specific access permissions for users or groups delete multiple rows deletes several selected rows from a specified sheet delete multiple rows by formula deletes several rows from a specified sheet based on the provided column (col) syntax delete a file permanently removes a specified file from your storage delete a single row deletes a specific row from a selected sheet delete a single row by formula deletes a specific row from a spreadsheet by specifying the column (col) identifier download a file downloads a specified file from the connected service to your make scenario download a sheet as csv downloads the selected spreadsheet as a csv file get multiple rows by formula fetches multiple rows from your data that match the specified col syntax formula get range values retrieves the content from a specified range of cells get a row by row number fetches the data from a specific row in a table by specifying its row number get a single row by formula fetches a specific row from your data that matches the criteria defined by the col syntax formula list files retrieves a list of all files contained within a specific workbook make an api call executes a custom api request to the connected service using your authorized credentials remove duplicates in range eliminates repeated values from the specified data range, ensuring each entry appears only once replace a file overwrites the contents of a specified existing file with new data search rows finds and retrieves rows from your data that match the specified search criteria send an email notification sends an email notification to a specified sheetrocks user to alert them about an update or action send an email report sends a formatted email containing a table based report to a specified sheetrocks user update file settings modifies the access permissions and privacy settings of a selected file update multiple cells updates the values of multiple cells across different rows and columns within a spreadsheet update multiple rows by formula updates several rows in a spreadsheet by matching values using the col syntax update a cell updates the value of a specific cell in your spreadsheet update a row updates the data in a specific row of a table, identified by its row number update a single row by formula updates a specific row in your spreadsheet by matching it with the provided col syntax upload a file inserts a new file as a worksheet into an existing workbook watch approved rows triggers when a row's value changes from "false" to "true" in the specified data table watch updated rows triggers when any changes are made to an existing row in your selected table templates you can look for more templates in https //www make com/en/templates , where you'll find thousands of pre created {{scenario plural lowercase}} sheetrocks resources you can have access to more resources related to this app on the following links https //community make com/search?q=sheetrocks https //sheet rocks https //sheet rocks https //www make com/en/integrations/sheet rocks