Skip to main content
Best answer

How do I put new Shopify abandoned checkouts into Google Sheets?

  • November 24, 2024
  • 7 replies
  • 36 views

I want to put Shopify abandoned checkouts (not abandoned carts) into Google Sheets.  However, all I see available is a Zap that does abandoned carts from Shopify.

 

Is there a way to get abandoned checkouts?  Can that be built with webhooks or some sort of API polling?

 

I don’t know much about coding, so I won’t understand a highly technical answer.  I’m looking for a general idea of how it would be possible.

Best answer by Troy TessaloneBest answer by Troy Tessalone

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.

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Badger
Forum|alt.badge.img+5
  • New
  • 134 replies
  • November 24, 2024

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.


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30925 replies
  • Answer
  • November 25, 2024

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!


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2337 replies
  • November 27, 2024

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?


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30925 replies
  • November 28, 2024

@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.