Using Google Sheet as a data source

Hi Bubblers,

Wondering if someone can help me.

I have an investment fund marketplace on Bubble. Currently, the product data are stored within Bubble’s native DB. Now, I am experimenting with using Google Sheet as a data source and have Bubble get product data using Bubble’s API Connector.

However, there are a number of data field in the product data that are either “List of Data Things” or “Option Set”, and when I initiated the call to Google Sheet, the data field can only be map to text.

Is there a way in which when I trigger a GET call from Google Sheet I can get Bubble to recognize certain data field to be “List of Data Thing” or “Option Set”?

Thanks
FundKernel Development