Skip to main content
Question

How to resolve blank rows in Google Sheets when recording sales from GHL

  • April 18, 2025
  • 5 replies
  • 40 views

I created a Zap for a client that records sales from GHL in Google Sheets. Every so often there is a blank line in the google sheet and a sale is not recorded. From my review it looks like this happens when multiple sales happen at the same time. 

Is there a way to space out the action if multiple triggers fire at the same time? Or is there another fix for this?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Mohammad_Shahzaib_Nawaz
Forum|alt.badge.img+3

Hey Kali,

You can use a Delay After Queue Step and add delay. Also you can add a filter step to validate that the data exists.

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34081 replies
  • April 18, 2025

Hi ​@Kali 

For us to have more info, post screenshots showing how your Zap steps are outlined.


  • Author
  • Beginner
  • 1 reply
  • April 18, 2025

Hi ​@Kali 

For us to have more info, post screenshots showing how your Zap steps are outlined.

Hi Troy,

This is the flow. It works well most of the time but then skip a record every 40-80 zaps. 

I’m not sure if a delay would work since then the records that came in at the same time would both be released at the same time (if I understand ​@Mohammad_Shahzaib_Nawaz suggestion).

Thanks for your advice!

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34081 replies
  • April 18, 2025

@Kali 

Zap action: Delay (After Queue)

Waits for a set amount of time after the last delay in a given queue.
Used to deal with race conditions and rate-limiting.

Help: https://zapier.com/apps/delay/integrations#help


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 3527 replies
  • April 21, 2025

Hi ​@Kali,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.