Custom functions


Use custom functions to fetch data




  • There are two custom functions available in the sheet where add-on is installed (need to open the add-on at least once to attach it to the sheet). Custom functions can be used like any other Google Sheet function, such as =SUM(A1), including specifying parameters from other sheet cells.

    Currently the following custom functions are available


    FACEBOOK_ACCOUNTS() - retrieve a list of available Facebook account names and ids


    FACEBOOK() - fetch data from Facebook


    Example: Get data for facebook account id "12345" for the current month.

    FACEBOOK("12345","account_name,spend,clicks,impressions","thismonth")

    Custom functions are limited to small amounts of data, and are currently in beta


    For a list of available metrics, refer to this document