How can I get 3000 rows at one time? I setup the Lookup Spreadsheet Rows (output as Line Items) in Google Sheets but it’s limited to 500 rows? Then I thought about creating another zap and starting from the bottom of data but that still only gets me to 1000 rows. I finally attempted to write a google script and add a webhook but I have no clue how to do it on a step-by-step basis. I’m new to this so it’s a lot to digest. Help!
Get more than 500 rows
Hi
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
Because you can create a custom API request to query for a desired range as indicated in the linked example.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/9b52939c-7f51-42af-bb48-2f8268c02cf5.png)
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.
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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2fa9d05d-cf7b-403d-b502-cb8815e38e5c.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4576bdfa-badd-4282-98ae-18c674f6b4a5.png)
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.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/121a41eb-2192-45ae-b767-942eeba8ae07.png)
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?
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
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/7e38c01e-0c33-499b-80ad-e1dff5547c54.png)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.