Creating a Custom Request

Creating Custom Request

This guide will walk through how to use the custom request feature with Phlorin to pull data from nearly any API into Google Sheets.

To start pulling data, find the API you want and search their official documentation to get the endpoints and parameters necessary. Optionally, use Phlorin’s built-in integration to skip the digging or use Phlorin’s database of guides to get the API documentation you seek.

Getting Started

Install the API solution add-on from Google Marketplace.

Creating a New Request

To get the most out of an API use Phlorin to pull data seamlessly into Google Sheets.

1. In your desired Sheets document, open Phlorin and create a new request:

Extensions > Phlorin > Open > Create a request

2. In the Application dropdown select or search for Custom

3. Next select the Request Method from the dropdown

>GET

>POST

>PUT

>PATCH

>DELETE

Depending on your choice or what you need, this will dictate the type of request you are running. Some requests may require body parameters, this will open up the option if need be.

4. Enter a Request URL. 

As mentioned before, available request URLs should be provided by your API’s documentation. See our guides for specific ones or find one from thousands of APIs on the web.

5. Input any necessary headers, parameters, or body.

6. Lastly, make sure your desired sheet is selected and click Run.

Need help creating your request?

Reach out to us: Contact support or join our community forum.