--- title: SheetRocks slug: sheet-rocks description: How to integrate SheetRocks with Make.com image: https://make-cxp-documentation.ams3.digitaloceanspaces.com/apps-center-icons/PREVIEW_sheet-rocks.png createdAt: 2025-12-13T22:13:48.848Z --- | :inlineImage[]{src="https://make-cxp-documentation.ams3.digitaloceanspaces.com/apps-center-icons/sheet-rocks.png" alt="SheetRocks logo" caption size="50" width="512" height="512"} | 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. | | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :::hint{type="warning"} 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 [SheetRocks](https://sheet.rocks) directly. ::: # Requirements To use the SheetRocks app in Make, you must have an active account and a BearerAuth token, [create your account on SheetRocks](https://sheet.rocks). For subscription, refer to the [SheetRocks pricing page](https://sheet.rocks). # Connect SheetRocks and Make To get started, you must first create a connection between SheetRocks and Make, allowing the two services to communicate. ::::WorkflowBlock :::WorkflowBlockItem **Obtain your API Key in your SheetRocks account** ::: :::WorkflowBlockItem **Create the connection in Make.** ::: :::: ## Obtain your API Key in your SheetRocks account Before you create the connection in Make, you should first obtain your **API Key** in your SheetRocks account. To obtain your **API Key **: ::::WorkflowBlock :::WorkflowBlockItem Navigate to the** API Keys** section from the account menu. ::: :::WorkflowBlockItem Copy the** API key** displayed on the screen. ::: :::: You will use this value while creating a connection in Make. Because the UI might have changed, the steps you see on your screen might be different, [check the vendor documentation for updates.](https://get.sheet.rocks/support/api-keys) ## Create the connection in Make :::::WorkflowBlock ::::WorkflowBlockItem [[Log in in your Make](https://www.make.com/en/register) account](https://www.make.com/en/register), add the SheetRocks module to your scenario, and click **Create a connection. ** :::hint{type="info"} If you add a module with an instant tag, click **Create a webhook**, then **Create a connection.** ::: :::: :::WorkflowBlockItem *Optional: *In the **Connection name** field, enter a name for the connection. ::: :::WorkflowBlockItem 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 **[Connect an application](docId\:SO88FM6pkT0G-adKDDfzZ)** page. # SheetRocks modules After connecting to the SheetRocks app, you can choose from a list of available modules to build your scenarios. :::ExpandableHeading ### Add Multiple Rows Inserts several new rows of data at the bottom of the selected spreadsheet. ::: :::ExpandableHeading ### Add a Row Inserts a new row with your specified data at the bottom of the selected spreadsheet. ::: :::ExpandableHeading ### Add a Sheet Creates a new worksheet within an existing workbook. ::: :::ExpandableHeading ### Clear Formatting in Range Removes all text and cell formatting from the specified range of cells. ::: :::ExpandableHeading ### Clear Values in Range Removes all data from the specified cell range, leaving the cells empty. ::: :::ExpandableHeading ### Create a New Permission Rule Creates a new rule that defines specific access permissions for users or groups. ::: :::ExpandableHeading ### Delete Multiple Rows Deletes several selected rows from a specified sheet. ::: :::ExpandableHeading ### Delete Multiple Rows by Formula Deletes several rows from a specified sheet based on the provided column (COL) syntax. ::: :::ExpandableHeading ### Delete a File Permanently removes a specified file from your storage. ::: :::ExpandableHeading ### Delete a Single Row Deletes a specific row from a selected sheet. ::: :::ExpandableHeading ### Delete a Single Row by Formula Deletes a specific row from a spreadsheet by specifying the column (COL) identifier. ::: :::ExpandableHeading ### Download a File Downloads a specified file from the connected service to your Make scenario. ::: :::ExpandableHeading ### Download a Sheet as CSV Downloads the selected spreadsheet as a CSV file. ::: :::ExpandableHeading ### Get Multiple Rows by Formula Fetches multiple rows from your data that match the specified COL syntax formula. ::: :::ExpandableHeading ### Get Range Values Retrieves the content from a specified range of cells. ::: :::ExpandableHeading ### Get a Row by Row Number Fetches the data from a specific row in a table by specifying its row number. ::: :::ExpandableHeading ### Get a Single Row by Formula Fetches a specific row from your data that matches the criteria defined by the COL syntax formula. ::: :::ExpandableHeading ### List Files Retrieves a list of all files contained within a specific workbook. ::: :::ExpandableHeading ### Make an API Call Executes a custom API request to the connected service using your authorized credentials. ::: :::ExpandableHeading ### Remove Duplicates in Range Eliminates repeated values from the specified data range, ensuring each entry appears only once. ::: :::ExpandableHeading ### Replace a File Overwrites the contents of a specified existing file with new data. ::: :::ExpandableHeading ### Search Rows Finds and retrieves rows from your data that match the specified search criteria. ::: :::ExpandableHeading ### Send an Email Notification Sends an email notification to a specified SheetRocks user to alert them about an update or action. ::: :::ExpandableHeading ### Send an Email Report Sends a formatted email containing a table-based report to a specified SheetRocks user. ::: :::ExpandableHeading ### Update File Settings Modifies the access permissions and privacy settings of a selected file. ::: :::ExpandableHeading ### Update Multiple Cells Updates the values of multiple cells across different rows and columns within a spreadsheet. ::: :::ExpandableHeading ### Update Multiple Rows by Formula Updates several rows in a spreadsheet by matching values using the COL syntax. ::: :::ExpandableHeading ### Update a Cell Updates the value of a specific cell in your spreadsheet. ::: :::ExpandableHeading ### Update a Row Updates the data in a specific row of a table, identified by its row number. ::: :::ExpandableHeading ### Update a Single Row by Formula Updates a specific row in your spreadsheet by matching it with the provided COL syntax. ::: :::ExpandableHeading ### Upload a File Inserts a new file as a worksheet into an existing workbook. ::: :::ExpandableHeading ### Watch Approved Rows Triggers when a row's value changes from "false" to "true" in the specified data table. ::: :::ExpandableHeading ### 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 [Make's template gallery](https://www.make.com/en/templates), where you'll find thousands of pre-created scenarios. # SheetRocks resources You can have access to more resources related to this app on the following links - [SheetRocks topics on Make community](https://community.make.com/search?q=SheetRocks) - [SheetRocks website](https://sheet.rocks) - [SheetRocks API documentation](https://sheet.rocks) - [SheetRocks page on make](https://www.make.com/en/integrations/sheet-rocks) *** :::CtaButton{label="Get started for free" externalHref="https://www.make.com/en/register" openInNewTab="true"} :::