It is possible, but you’ll need someone with technical knowledge of Shopify and Zapier. 

• Create a private app inside your Shopify account with permissions to read checkouts.
• Create a scheduled Zap to request the abandoned checkouts at a specific interval perhaps daily. 
• The set up the webhook with your private app’s access token, to post your query to fetch the abandoned checkouts in JSON.
• Then you can use the data in your Zap, probably with looping to add to rows in your Google Sheet.

For the Shopify API refer to https://shopify.dev/docs/api/admin-graphql/2024-10/queries/abandonedCheckouts

I don’t believe you’ll be able to trigger from an abandoned checkout, though. 

I hope this is useful.

Hi ​@wishiknewhowtocode 

Feedback from ChatGPT:

To automate the process of recording Shopify's abandoned checkouts into Google Sheets using Zapier, you can utilize Shopify's REST API in combination with Zapier's Webhooks feature. Here's a general approach to achieve this:

1. Set Up a Scheduled Zap in Zapier:

   • Create a new Zap in Zapier and choose the "Schedule by Zapier" app as the trigger.
   • Configure it to run at your desired frequency (e.g., daily or hourly).

2. Use Zapier's Webhooks to Retrieve Abandoned Checkouts:

   • Add an action step using the "Webhooks by Zapier" app.
   • Select the "GET" method to fetch data.
   • In the URL field, enter Shopify's endpoint for retrieving abandoned checkouts: https://your-store-name.myshopify.com/admin/api/2024-01/checkouts.json.
   • Replace your-store-name with your actual Shopify store name.
   • In the headers section, include your Shopify API credentials to authenticate the request.

3. Filter and Format the Data:

   • If necessary, add a "Filter" step in Zapier to process only the relevant data.
   • Use "Formatter by Zapier" to structure the data appropriately for Google Sheets.

4. Send Data to Google Sheets:

   • Add a "Google Sheets" action to your Zap.
   • Choose the "Create Spreadsheet Row(s)" action to insert the retrieved data into your desired spreadsheet.

This setup allows Zapier to periodically fetch abandoned checkout data from Shopify and record it into Google Sheets without requiring advanced coding skills.

Thanks for your help!

Hi ​@wishiknewhowtocode,

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.

To be clear ​@JammerS, I haven’t put Troy’s resolution into practice yet.  When I do, I’ll update this thread.

In other words, results are still pending.

​@Troy Tessalone

How does Step 2 (Zapier webhook) change since the REST API is now legacy, according to Shopify?  Does anything change?

​@wishiknewhowtocode 

You can still use the Shopify GraphQL API in Zaps via the cURL structure examples in the API documentation.

Ask ChatGPT if you need help formatting the API request.