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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 27637 replies
-
6 June 2024
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
Userlevel 7
+14
- Certified Zapier Expert
- 27637 replies
-
6 June 2024
Because you can create a custom API request to query for a desired range as indicated in the linked example.
Userlevel 7
+14
- Certified Zapier Expert
- 27637 replies
-
6 June 2024
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.
Userlevel 7
+14
- Certified Zapier Expert
- 27637 replies
-
6 June 2024
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.
Userlevel 7
+14
- Certified Zapier Expert
- 27637 replies
-
6 June 2024
Screenshots doesn’t show the first 2 steps for context.
Userlevel 7
+14
- Certified Zapier Expert
- 27637 replies
-
6 June 2024
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.
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?
Userlevel 7
+14
- Certified Zapier Expert
- 27637 replies
-
6 June 2024
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.