The OpenAI Ads Manager for ChatGPT ads is currenty in Beta and we're already seeing a few Shopify merchants use our EZ Exporter app to push product data from Shopify to it.

We've created a template for it which already incudes all the required fields. Fields such as the title and description are also already configured to not exceed the maximum character limit defined by OpenAI.

Below are the steps on how to configure our app to …

Google Sheets supports exporting data to a bunch of formats such as CSV, Excel, and PDF. However, it doesn't support exporting data to JSON.

While the most popular and widely used data export format is CSV, there are some platforms that don't support it.

This use case actually came up from a customer of our Shopify data export app, EZ Exporter, where they wanted to export a custom product catalog of their Shopify product data to use …

If you have a spreadsheet that has a column with a comma-separated list of values (like URLs), you can easily combine them and create a separate row for each one in Google Sheets using a formula like this:

=TRANSPOSE(SPLIT(JOIN(",", Sheet1!B2:B), ","))

The formula above references column B of Sheet1, where each row's Column B is a comma-separated list of URLs for each product on a Shopify store.

Here's what the formula does:

1. JOIN(",", Sheet1!B2:B) …

Google Sheets has an IMPORTRANGE function that allows you to import a range of cells from another spreadsheet and requires you to enter the spreadsheet's URL.

But what if you just want to reference data from another sheet within the same spreadsheet?

A simpler approach is to use the QUERY function instead.

A Quick Example

We can use this formula to pull the values from columns A and B of Sheet1:

=QUERY(Sheet1!A:B)

Here's the …

Shopify supports very granular permissions that can be given to individual staff accounts. This is a really good way to improve security as you can limit each staff's access to only those parts of the Shopify Admin that are necessary to do their job.

As app developers, we sometimes get questions when a member of a merchant's team can't install or approve app charges, preventing them from using our app.

Most of our apps use recurring subscriptions via …