Hi @Robo2030 

That can be done using the GSheets API via one of these actions: https://developers.google.com/sheets/api/samples/reading#single-range

• API Request
• Custom Action (with the help of AI)

Hi @Troy Tessalone, sorry, that doesn’t really help me much. How will one of those actions allow for 3000 rows?

@Robo2030 

Because you can create a custom API request to query for a desired range as indicated in the linked example.

@Robo2030 

I think the bigger question though, is WHY do you need to get 3k rows from a GSheet?

Perhaps there is a more optimized approach to your problem.

@Troy Tessalone Certainly! I have customer contact information for appointment reminders that we send to clicksend and it’s about 3000 rows of past, current and upcoming appointments.

@Robo2030 

You need all 3,000 rows at once?

What are the workflows steps you are trying to configure? (trigger + actions)

If you’re trying to do a 1 time transfer, then it may be more pragmatic to do an export/import of the data between the apps.

@Troy Tessalone Here’s a screenshot of what I’m currently doing:

@Robo2030 

Screenshots doesn’t show the first 2 steps for context.

@Troy Tessalone 

@Robo2030 

To confirm, you are trying to have a weekly scheduled Zap run that finds 3k rows in the GSheet, the loops thru each row to lookup something in a GSheet, then send and SMS?

The purpose of GSheet step 6 is unclear.

Seems like you ought to be using ClickSend Contact Lists to handle the Contact info and SMS sending.

Then you could use this Zap action: ClickSend - Send SMS to Contact List

There are other ClickSend Zap actions related to “Lists” that may be useful.

@Troy Tessalone 

Step 6 filters customers that may not have a phone number

Also, this google sheet is integrated with our companies database and updates every morning. Since we wanted it automated, I didn’t think we could use the clicksend contact lists since those need to be uploaded manually?

@Robo2030 

In my professional opinion, I do NOT recommend taking the approach of using Zaps to try to send 3k+ SMS weekly via ClickSend.

• That can become costly.
• You run the risk of hitting ClickSend API limits for that much activity in a short amount of time.
• The purpose of ClickSend Contact Lists is to manage a large list of contacts and to handle smooth sending on your behalf.

I can’t image the data for all 3k+ contacts is being updated every morning.

Ideally, only contacts that were actually updated would be acted upon to then be updated in ClickSend.

In ClickSend, Contacts can be created/updated and put in Contact Lists.

SMS can be send out based on Contact Lists.

You should be able to schedule the SMS to be sent weekly in ClickSend.

https://help.clicksend.com/article/thh681s18c-how-to-schedule-a-quick-sms-or-sms-campaign