Create API Request Based on a Cell

Create API Request Based on a Cell

Last Updated On July 07, 2019
You are here:
< Back

One of the advantages of using the API Connector for Google Sheets is that API URL requests can be based on dynamic or fixed values within your spreadsheet. This is a very flexible function that enables you to, for example, use an automatically updated date in a spreadsheet as the start or end date of a query.

Method 1: Reference cell containing URL

To use this function, wrap your cell reference in 3 plus signs on either side. (The plus signs tell API Connector that this is a cell reference and not part of the original URL.) So a reference to cell B2 in a tab called QuerySheet would be written like this: +++QuerySheet!B2+++

api-connector-cell-references-img1

Method 2: Combine fixed values and cell references

Your request field can also contain a combination of fixed values and cell references. Just wrap the cell reference piece in 3 plus signs as described above, like this:

api-connector-cell-references-img2

Notes

  • The cell you’re referencing can use all the standard formulas and syntax of Google Sheets. In the first example above, cell B2 contains the following formula:
     
  • For additional efficiency, you can combine cell references together into a single request. (Please note this is a paid feature).

Comments:5

  1. So, linking to cells for a POST is now possible? If so, can the body of a request be dynamic based with fields tied to cells?

Leave a Reply

Your email address will not be published.