ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
First, please watch the tutorial video Lesson1 and complete the initial setup.
2
How to use (Japanese only)
https://theaisprint.info/ai-writing-e-learning/googlesheets-gpt-automation-how-to-use/
3
4
1. For information on how to obtain the API, please refer to this guide.
5
GPT(OpenAI)
https://theaisprint.info/chatgpt-api-how-to-get/
6
Claude(Anthropic)
https://youtu.be/N39f_TibfLs
Anthropic Website
https://claude.ai/
7
8
2. Copy and paste the obtained API key into the cell filled in black.
9
10
11
3. With this, the API key setting is complete. Please go back to the “How to use” tab and check the usage.
12
13
14
Frequently Asked Questions
15
Q
I get an error when I execute and can’t get a response
16
A
The common causes are as follows. Please check on OpenAI’s API settings page.
17
- No available API tokens left → Please purchase on OpenAI’s Billing page
18
- The free usage period has expired (even if it wasn’t used up, it can’t be used because it’s expired) → Please purchase on OpenAI’s Billing page
19
20
Q
I can’t enter the API key (I can’t edit the sheet)
21
A
Please use the shared sheet by creating a copy from “File” > “Copy”.
22
- The shared sheet is set to view-only (if it’s editable, the API key would leak to everyone it’s shared with)
23
24
Q
When I process multiple prompts together, I get an “Error: Exceeded time limit”. Why is that?
25
A
Due to Google Apps Script’s limitations, this error occurs when the script execution time exceeds 6 minutes. If you clear the error and reconnect to GPT, you can get the continuation of the response.
26
27
Feature Request Form
28
https://forms.gle/9dFmiJhJJdqP1W6t5
29
30
Bug report
31
https://forms.gle/FfJaYSQY16pGeEvr8
32
33
34
Terms of Use

This script is provided “as is”, without any express or implied warranties. This includes, but is not limited to, implied warranties of fitness for a particular purpose, merchantability, or non-infringement.

The author is not liable for any direct, indirect, incidental, special, consequential, or exemplary damages (including, but not limited to, loss of profits, business interruption, loss of information, or other monetary loss) resulting from the use of this script, regardless of the reason, whether in contract, strict liability, or tort (including negligence).

This script is intended for personal use only. Redistribution and sale are prohibited.

By downloading or duplicating this script, the user is considered to have agreed to the above conditions.
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100