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
• Method 2: Combine fixed values and cell references
• Notes

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+++

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:

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:
  
  ="http://api.shareablee.com/v1.4/user/"&E2&"/facebook/time_series/"&"?start_date="&to_text(C2)&"&end_date="&to_text(D2)

  1	="http://api.shareablee.com/v1.4/user/"&E2&"/facebook/time_series/"&"?start_date="&to_text(C2)&"&end_date="&to_text(D2)

   
• For additional efficiency, you can combine cell references together into a single request. (Please note this is a paid feature).