Run Selected Range

Overview

The Run Selected Range feature allows you to execute multiple custom functions across a selected range of cells in your Google Sheet. This feature is particularly useful when you need to process multiple cells containing task functions in sequence.

How to Use

Basic Steps

1. Select the range of cells containing your task functions (e.g., TASK_LM, TASK_FORMAT, etc.)
2. Open the addon sidebar
3. Click the "Run" button in the sidebar after selecting your cells
4. Watch as each cell in your selection is processed in sequence

Advanced Usage: Rate Limiting

You can control how quickly cells are processed using the RPM (Rate Per Minute) setting:

1. Locate the RPM input field above the Run button
2. Enter your desired maximum number of cells to process per minute
3. Run your selected range as normal

Example Scenarios

Scenario 1: Basic Processing

1. Enter task functions in cells A1:A5
2. Select those cells
3. Click Run
4. Each cell will be processed in sequence

A1: =TASK_LM("Summarize this paragraph", "Gemini/gemini-1.5-pro")

A2: =TASK_FORMAT("Make text bold", "Gemini/gemini-1.5-pro")

A3: =TASK_LM("Create a title", "Gemini/gemini-1.5-pro")

Scenario 2: Rate-Limited Processing

1. Enter task functions in cells A1:A20
2. Set RPM to 30 (process up to 30 cells per minute)
3. Select the range
4. Click Run
5. Cells will be processed with pauses to maintain the rate limit

Best Practices

1. Review Before Running: Always review your selected range before running to ensure you're processing the intended cells

2. Start Small: When working with new functions, start with a small range to test the behavior

3. Use Rate Limiting: For large ranges, consider using rate limiting to prevent overloading. This is very relevant when engaging moelds that have real rate limits such a the free version of Google Gemini

4. Monitor Progress: Watch the status notifications to track progress and catch any errors

Troubleshooting

Common issues and solutions:

1. Nothing Happens When Clicking Run

   • Verify you have selected a range
   • Check that the selected cells contain valid task functions

2. Processing Stops Unexpectedly

   • Check the error message in the notification
   • Verify your function parameters are correct
   • Ensure you have necessary permissions

3. Rate Limiting Not Working

   • Verify you entered a valid number in the RPM field
   • Make sure the RPM value is greater than zero

Tips

1. Process cells from right to left within each row to prevent overwriting input cells

2. Use rate limiting for ranges larger than 20 cells to ensure stable processing

3. Keep an eye on the notification area for progress updates and any error messages

4. Save your work before running large ranges of cells

Support

If you encounter issues not covered in this guide:

1. Click the Help button in the sidebar
2. Use the Feedback button to report problems
3. Check the error message for specific details about what went wrong

This feature is designed to make batch processing of tasks efficient while maintaining control over the execution rate and providing clear feedback about the progress and any issues that arise.