---
title: Google Sheets tips and examples
slug: google-sheets-tips-and-examples
image: https://make-cxp-documentation.ams3.cdn.digitaloceanspaces.com/apps-center-icons/PREVIEW_DEFAULT.png
createdAt: 2025-03-12T12:23:59.227Z
---

Explore the following tips and examples to help you build your scenarios with Google Sheets modules.

:::::ExpandableHeading
## Add a custom button in a sheet to trigger a scenario

::::WorkflowBlock
:::WorkflowBlockItem
In Make insert the **Webhook > Custom webhooks** module/trigger into the scenario and configure it (see the webhooks article).

Once you have configured the custom webhook module, be sure to save the scenario.
:::

:::WorkflowBlockItem
Copy the webhook's URL.
:::

:::WorkflowBlockItem
Run the scenario.
:::

:::WorkflowBlockItem
In Google Sheets, choose **Insert > Drawing** from the main menu bar.
:::

:::WorkflowBlockItem
Click the **Text box** icon:

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/Apn4xB5k94Bo2tLSWxWNb_uuid-9b2000f5-7232-32c9-a777-5db52218ebbc.png" size="60" width="360" height="145" position="flex-start" alt="Text box icon" showCaption="false"}
:::

:::WorkflowBlockItem
Design a button and click **Save and Close** in the top-right corner:

![Design a button](https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/WQYPGkcydvAbMvasOXH-d_uuid-6f196bb3-0b81-421e-b7e6-afb367ef0d32.png)
:::

:::WorkflowBlockItem
The button will be placed in your worksheet. Click the three vertical dots in the button's top-right corner:

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/z3Vxo_DpHNprr0ECQ9Yeo_uuid-c274e33a-432f-9b35-ab7b-939cbd423267.png" size="50" width="273" height="219" position="flex-start" alt="Button in Google Sheets" showCaption="false"}
:::

:::WorkflowBlockItem
Choose **Assign script** from the menu.
:::

:::WorkflowBlockItem
Enter the name of your script (function). For example, `runMake`and click **OK**:

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/43Vy0AP1RgOP03HcGt5ib_uuid-163fdb3c-95cc-c3eb-155f-ca9e7b15d3f5.png" size="60" width="405" height="256" position="flex-start" alt="Assign script" showCaption="false"}
:::

:::WorkflowBlockItem
Choose **Extensions > Apps Script** from the main menu bar.
:::

:::WorkflowBlockItem
Insert the following code:

```none
function runScenario() {
UrlFetchApp.fetch("https://hook.make.com/xxx...xxx");
}
```
:::

:::WorkflowBlockItem
Press **Ctrl+S** to save the script file, enter a project name, and click **OK**.
:::

:::WorkflowBlockItem
Switch back to Google Sheets and click your new button.
:::

:::WorkflowBlockItem
Grant the required authorization to the script.
:::

:::WorkflowBlockItem
In Make, verify that the scenario has successfully executed.
:::
::::

:::hint{type="info"}
This will only trigger a scenario to run when Scheduling is enabled. The linked webhook URL will not return any data but instead will trigger the scenario to run and allow the connected modules to return data.
:::
:::::

::::::ExpandableHeading
## Delete multiple rows

To delete multiple rows based on filter criteria, use the **Search Rows** module linked to the **Delete a Row** module as in the following example:

:::::WorkflowBlock
:::WorkflowBlockItem
Add the **Search Rows** module and the **Delete a Row** module to the scenario.
:::

:::WorkflowBlockItem
Let's assume that you have a table where you need to delete all rows where column **A** equals **Y**.
:::

:::WorkflowBlockItem
Open the **Search Rows** module settings and set the fields as follows:

- **Filter:** Set **A** Equal to **Y**
- **Sort order:** Descending
- **Order by:** Row number
:::

:::WorkflowBlockItem
Add the **Delete a Row** module to the scenario and connect it to the **Search Row** module.
:::

::::WorkflowBlockItem
Map the **Row number item** from the **Search Rows** module to the Delete a Row module's **Row number** field.

:::ExpandableHeading{isOpen="true"}
![Google_Sheets_map_delete_row](https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/fqKwU0CY73qWTkXejTUSh_uuid-6ba52cff-bd61-b1c0-9987-c6e940b5f0c0.png)
:::
::::

:::WorkflowBlockItem
Run the scenario to delete values that match the filter criteria from the sheet.
:::
:::::




::::::

:::ExpandableHeading
## Get empty cells from a Google Sheet

Use the **Search Rows (Advanced)** module and use this formula to get empty columns.

```text
 select * where E is null
```

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/ija_qE8DOuP5ZJuGglqmi_uuid-ab9cfd7e-3d50-03c4-fd6b-dcb19d7279f9.png" size="90" width="1360" height="1278" position="flex-start" alt="Google_sheets_adv_search_rows" showCaption="false"}

Here **"E"&#x20;**&#x69;s the column and **"is null"** is the condition. You can create a more advanced query using  [Google Query Lang](https://developers.google.com/chart/interactive/docs/querylanguage).
:::

:::ExpandableHeading
## Make an API call

The following API call returns specified spreadsheet details.

**URL:**

`/spreadsheets/{{spreadsheetID}}`

**Method:**

`GET`

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/wwIcutFIf5PyczQaDOI8q_uuid-c0a9366f-f807-7bcf-4051-bdd5871d3dcd.png" size="60" width="816" height="1618" position="flex-start" alt="Google Sheets Make an API call" showCaption="false"}

The result can be found in the module's **Output** under **Bundle > Body:**

![Make an API call bundle output](https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/0iVwgYzHhcPwGu-zP7IE8_uuid-f481a996-3740-f8b0-49a9-6512ffebba6e.png)
:::

:::ExpandableHeading
## Post and get images from Google Sheets

When getting an image from Google Sheets, first make sure you enter the image as a formula. For example:`=IMAGE("https://i.ytimg.com/vi/MPV2METPeJU/maxresdefault.jpg")` making use of the =IMAGE(...)

![Image formula](https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/SxbRaJDZOROf-mnqqCY0F_uuid-607e470a-c954-e582-7cf7-7fa4188aceda.png)

After you have done so, open the Google Sheets module (e.g. **Watch Rows, Search Rows, Get a Cell**) and select **Show advanced settings**. Then select the Formula option in the **Value render option** field.

The output will be as shown below:

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/Wvy20Q-oZSZ4mE1J9z51u_uuid-1b4bee4b-a620-519b-8c7f-05059438bab6.png" size="80" width="511" height="361" position="flex-start" alt="Output" showCaption="false"}

Then you can extra the URL using the replace function.

The output will just be the URL.

To be able to post an image, make sure to enter the `=IMAGE(...)` formula that will be used in the cell and then enter the Image URL address.

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/xA4pNqTYRs_XliJJCMgns_uuid-418cf0b7-0e34-c3ed-a101-af4d68efad9f.png" size="70" width="338" height="138" position="flex-start" alt="Image formula" showCaption="false"}
:::

:::ExpandableHeading
## Store dates in a spreadsheet

If you store a **Date** value in a spreadsheet without any formatting, it will appear as text in [ISO 8601 format](https://en.wikipedia.org/wiki/ISO_8601) in the spreadsheet. However, Google Sheets formulas or functions that work with dates do not understand this text. For example, the formula `=A1+10` will display the following error:

![Store dates in a spreadsheet - date error](https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/PWZc6MC7HxYdgcwRS3vja_uuid-8bd638b4-ec78-c414-da3f-0f9f065784e1.png)

To help the GS to understand the date, format it with the formatDate(.) function. The correct format passed to the function as the second argument depends on the spreadsheet's locale settings. Choose **File** > **Spreadsheet settings** from the main menu to verify/set the locale.

Once you have verified/set the proper locale, determine the corresponding date and time format by choosing **Format > Number** from the main menu. The format is displayed next to the **Date time** menu item.

The following example shows the use of `M/D/YYYY HH:mm:ss` format for the United States locale:

![Google Sheets date format example](https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/Vm23l4NqrirbtesZhVk0A_uuid-b76b3fb6-61f3-7a74-3067-3f77964b7fcc.png)
:::

:::ExpandableHeading
## Usage limits

If the error **429: RESOURCE\_EXHAUSTED&#x20;**&#x6F;ccurs, you have exceeded the API rate limit.

The Google Sheets API has a limit of 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. Limits for reads and writes are tracked separately. There is no daily usage limit.

See more details at [developers.google.com/sheets/api/limits](https://developers.google.com/sheets/api/limits).
:::

:::::ExpandableHeading
## Use a function

In the following scenario, a function is used to convert a currency value according to current exchange rates.

::::WorkflowBlock
:::WorkflowBlockItem
Create a scenario with the following modules:

![Use a function example](https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/LJWXyy-bEb-q2GoKOmQC6_uuid-433924ed-a1df-c9f8-5e8b-839f5afd07a8.png)
:::

:::WorkflowBlockItem
In the **Google Sheets > Perform a Function** module, generate a webhook and paste it into the scenario add-on in Google Sheets.

::Image[]{src="https://api.archbee.com/api/optimize/yAufeXqD1oGWOPBNi5MAm-JIvK7OMqyhq_fXwPyEjyq-20250313-092349.png" size="60" width="826" height="700" position="flex-start" alt="Generate a webhook" showCaption="false"}
:::

:::WorkflowBlockItem
In the **Currency > Convert an Amount between Currencies** module, convert the mapped EUR amount to USD.

::Image[]{src="https://api.archbee.com/api/optimize/yAufeXqD1oGWOPBNi5MAm-8A1zGBz6BgC38IC8RWl9c-20250313-092519.png" size="60" width="828" height="752" position="flex-start" alt="Convert currency" showCaption="false"}
:::

:::WorkflowBlockItem
In the **Google Sheets > Perform a Function - Responder** module, insert the converted amount into the sheet cell.

![Insert converted value](https://api.archbee.com/api/optimize/yAufeXqD1oGWOPBNi5MAm-IIcM6umw9IfRlewpRR_9T-20250313-092630.png)
:::

:::WorkflowBlockItem
Run the scenario.
:::

:::WorkflowBlockItem
Enter the `MAKE_FUNCTION` into the desired cell to load the converted amount.

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/j859bB-nAY45nuAHP-KH-_uuid-679fcfcd-17aa-1fae-e877-d8a537d39447.gif" size="62" width="339" height="290" position="flex-start" alt="User enters amount" showCaption="false"}
:::
::::

When the user changes the amount, the `MAKE_FUNCTION` re-calculates the **Total - USD** according to the current exchange rate:

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/RcJOR-niu1hzqg6EW6ATY_uuid-3ad043fc-8d85-1d2d-8f11-af1bc4f444bc.gif" size="80" width="441" height="397" position="flex-start" alt="Currency converted" showCaption="false"}
:::::

