I want to exceed the request limit on the spreadsheet.

You should not exceed the limit, but
I don't think it's necessary to divide every 1000 pieces into different programs.
However, there are other restrictions that should be considered.

The https://tanuhack.com/operate-spreadsheet/ #Python" source has no validation, but may be API request restrictions and assignments

Below is a quote.

General allocation limits

The following assignments apply to the Management API, Core Reporting API v3, MCF Reporting API, Metadata API, User Deletion API, and Real Time Reporting API.

• 50,000 requests per day per project.
• 10 queries per second (QPS) per IP address.
  • The API Console has a similar allocation limit of requests per 100 seconds per user.By default, it is set to 100 requests per 100 seconds per user.The maximum value that can be configured is 1,000.However, the number of API requests is limited to 10 per second per user.
  • If the application makes all API requests from one IP address (that is, on behalf of the user), use the userIP or quotaUser parameters in each request so that the QPS limit is assigned to each user.For more information, see the overview of standard query parameters.

• The API Console has a similar allocation limit of requests per 100 seconds per user.By default, it is set to 100 requests per 100 seconds per user.The maximum value that can be configured is 1,000.However, the number of API requests is limited to 10 per second per user.
• If the application makes all API requests from one IP address (that is, on behalf of the user), use the userIP or quotaUser parameters in each request so that the QPS limit is assigned to each user.For more information, see the overview of standard query parameters.

It seems that the person who asked the question mentioned it on the reference page, but I think you need to consider the following limitations:

Limits and Assignments to API Requests

• 100 requests per 100 seconds
• The number of requests to the API is limited to 10 per second per user.