Streaming live at 10am (PST)

Offsets and Rate Limits


Hello, I have 312 pieces of content that I want to fix the date on. But I can only seem to grab the first 100, and I notice that there is a limit of 100. Even when I set offsets, I still seem to be grabbing the same set of data. I think I’m missing something.

Here’s the code I’m running:

My thinking is that offset=1 is the first 1-100 items, and offset=2 is the second 101-200 items, etc. But that does not seem to be the case.

I also keep hitting the rate limit, which makes it a real pain to debug. Any tips on how to slow down the process to <60 calls per minute? Besides manually chunking the formula.

I am also using Google Scripts which times out at 300 seconds, so I can only run five automated chunks before it times out.