Custom content generation within Sheets
You can perform any text-based task within Google Sheets using the Custom prompt bulk tool. This guide walks you through generating marketplace titles for pieces of furniture based on their description, and optimizing these results.
While you can also use the GPT function to perform this task, we'll focus on using the Custom prompt bulk tool in this guide.
Step 1: Get started
Prerequisites
- You have installed GPT for Sheets.
- You have opened a spreadsheet containing text to edit in a column.
Open the GPT for Sheets add-on and run the Custom prompt bulk tool with your prompt Write a marketplace title for this product: {{A}} on a few rows to see how it works.
If you find the answers satisfactory, go ahead and generate titles in bulk! Otherwise, check how to improve your results in Step 2.
Step 2: Improve your results (optional)
To obtain the best results when generating custom content, consider the following approaches:
| Goal | Recommended approach |
|---|---|
| Enhance instruction adherence | Select the gpt-4o model gpt-4o handles more nuances and follows instructions more accurately than most models. It is also much cheaper and faster than gpt-4 and gpt-4-turbo Learn more. |
| Boost accuracy | Add custom instructions Include context and specific rules to follow. |
| Improve coherence | Set the creativity level The creativity level must be adapted to the task. Use a high level for a creative writing task. |
| Use information from other cells | Reference more columns, cells or ranges If the model needs more context, you can reference more columns, cells and ranges in the prompt. |
Best practice: Compare various results by putting the results in a new column each time you change the settings.
Once you have refined your approach and are satisfied with the results from the initial rows, you are ready to launch your custom prompt in bulk. Select more cells or even all cells, click Run rows, and watch GPT for Sheets generate the rest of the titles.