Google Sheets Import & Export
Try for free
No credit card required
Go to Store
Google Sheets Import & Export
lukaskrivka/google-sheets
Try for free
No credit card required
Import data from datasets or JSON files to Google Sheets. Programmatically process data in Sheets. Easier and faster than the official Google Sheets API and perfect for importing data from scraping.
You can access the Google Sheets Import & Export programmatically from your own applications by using the Apify API. You can choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.
1{
2 "openapi": "3.0.1",
3 "info": {
4 "version": "2.0",
5 "x-build-id": "PRxRzIHT7IcaQtN4Y"
6 },
7 "servers": [
8 {
9 "url": "https://api.apify.com/v2"
10 }
11 ],
12 "paths": {
13 "/acts/lukaskrivka~google-sheets/run-sync-get-dataset-items": {
14 "post": {
15 "operationId": "run-sync-get-dataset-items-lukaskrivka-google-sheets",
16 "x-openai-isConsequential": false,
17 "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
18 "tags": [
19 "Run Actor"
20 ],
21 "requestBody": {
22 "required": true,
23 "content": {
24 "application/json": {
25 "schema": {
26 "$ref": "#/components/schemas/inputSchema"
27 }
28 }
29 }
30 },
31 "parameters": [
32 {
33 "name": "token",
34 "in": "query",
35 "required": true,
36 "schema": {
37 "type": "string"
38 },
39 "description": "Enter your Apify token here"
40 }
41 ],
42 "responses": {
43 "200": {
44 "description": "OK"
45 }
46 }
47 }
48 },
49 "/acts/lukaskrivka~google-sheets/runs": {
50 "post": {
51 "operationId": "runs-sync-lukaskrivka-google-sheets",
52 "x-openai-isConsequential": false,
53 "summary": "Executes an Actor and returns information about the initiated run in response.",
54 "tags": [
55 "Run Actor"
56 ],
57 "requestBody": {
58 "required": true,
59 "content": {
60 "application/json": {
61 "schema": {
62 "$ref": "#/components/schemas/inputSchema"
63 }
64 }
65 }
66 },
67 "parameters": [
68 {
69 "name": "token",
70 "in": "query",
71 "required": true,
72 "schema": {
73 "type": "string"
74 },
75 "description": "Enter your Apify token here"
76 }
77 ],
78 "responses": {
79 "200": {
80 "description": "OK",
81 "content": {
82 "application/json": {
83 "schema": {
84 "$ref": "#/components/schemas/runsResponseSchema"
85 }
86 }
87 }
88 }
89 }
90 }
91 },
92 "/acts/lukaskrivka~google-sheets/run-sync": {
93 "post": {
94 "operationId": "run-sync-lukaskrivka-google-sheets",
95 "x-openai-isConsequential": false,
96 "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
97 "tags": [
98 "Run Actor"
99 ],
100 "requestBody": {
101 "required": true,
102 "content": {
103 "application/json": {
104 "schema": {
105 "$ref": "#/components/schemas/inputSchema"
106 }
107 }
108 }
109 },
110 "parameters": [
111 {
112 "name": "token",
113 "in": "query",
114 "required": true,
115 "schema": {
116 "type": "string"
117 },
118 "description": "Enter your Apify token here"
119 }
120 ],
121 "responses": {
122 "200": {
123 "description": "OK"
124 }
125 }
126 }
127 }
128 },
129 "components": {
130 "schemas": {
131 "inputSchema": {
132 "type": "object",
133 "properties": {
134 "mode": {
135 "title": "Mode",
136 "enum": [
137 "append",
138 "replace",
139 "modify",
140 "read",
141 "load backup"
142 ],
143 "type": "string",
144 "description": "What should the actor do",
145 "default": "append"
146 },
147 "spreadsheetId": {
148 "title": "Spreadsheet id",
149 "type": "string",
150 "description": "Id of the spreadsheet from where the old data will be loaded"
151 },
152 "publicSpreadsheet": {
153 "title": "Public spreadsheet (read-only)",
154 "type": "boolean",
155 "description": "If checked, you don't need to authorize. You have to publish your spreadsheet and it works only in read mode",
156 "default": false
157 },
158 "datasetId": {
159 "title": "Dataset ID",
160 "type": "string",
161 "description": "Dataset or crawler execution id where the new data will be loaded from"
162 },
163 "rawData": {
164 "title": "Raw data",
165 "type": "array",
166 "description": "Raw data JSON array. Can be array of arrays for direct row import or arrays of objects."
167 },
168 "limit": {
169 "title": "Limit items",
170 "minimum": 0,
171 "type": "integer",
172 "description": "Number of items to take from the dataset. The default is 250000.",
173 "default": 250000
174 },
175 "offset": {
176 "title": "Offset items",
177 "minimum": 0,
178 "type": "integer",
179 "description": "Number of items to skip from the dataset. Default is 0.",
180 "default": 0
181 },
182 "deduplicateByField": {
183 "title": "Deduplicate by field",
184 "type": "string",
185 "description": "Items will be deduplicated by a value of this field. Cannot be used together with 'Deduplicate by equality' or 'Transform function'."
186 },
187 "deduplicateByEquality": {
188 "title": "Deduplicate by equality",
189 "type": "boolean",
190 "description": "Items will be deduplicated if they are the same. Cannot be used together with 'Deduplicate by field' or 'Transform function'."
191 },
192 "transformFunction": {
193 "title": "Transform function",
194 "type": "string",
195 "description": "Custom function that will take new items and old items arrays as parameters and produces final array that will be imported. Cannot be used together with 'Deduplicate by equality' or 'Deduplicate by field'"
196 },
197 "range": {
198 "title": "Range",
199 "type": "string",
200 "description": "Range of the spreadsheet in A1 notation where the actor should operate. Default is the first sheet."
201 },
202 "columnsOrder": {
203 "title": "Columns order",
204 "type": "array",
205 "description": "Array of keys. First sorts the columns by provided keys. The rest is sorted alphabetically.",
206 "items": {
207 "type": "string"
208 }
209 },
210 "keepSheetColumnOrder": {
211 "title": "Keep column order from sheet",
212 "type": "boolean",
213 "description": "If true, keeps the order of columns as they are in the sheet. If there is no sheet data yet, this does nothing."
214 },
215 "tokensStore": {
216 "title": "Google OAuth tokens store",
217 "type": "string",
218 "description": "Key-value store where your Google OAuth tokens will be stored so you don't have to authorize every time again. By default it is google-oauth-tokens",
219 "default": "google-oauth-tokens"
220 },
221 "createBackup": {
222 "title": "Create backup",
223 "type": "boolean",
224 "description": "Old rows from your spreadsheet will be saved to the default key-value store before importing new rows."
225 },
226 "backupStore": {
227 "title": "Backup store id",
228 "type": "string",
229 "description": "Id of the key-value store where the backup you want to load is located. Can pnly be used if mode is 'load-backup'"
230 },
231 "googleCredentials": {
232 "title": "Google Developer Console credentials",
233 "type": "object",
234 "description": "If you want to use this actor locally or with your own version, you have to provide your own crednetials. Check actor readme for more information."
235 }
236 }
237 },
238 "runsResponseSchema": {
239 "type": "object",
240 "properties": {
241 "data": {
242 "type": "object",
243 "properties": {
244 "id": {
245 "type": "string"
246 },
247 "actId": {
248 "type": "string"
249 },
250 "userId": {
251 "type": "string"
252 },
253 "startedAt": {
254 "type": "string",
255 "format": "date-time",
256 "example": "2025-01-08T00:00:00.000Z"
257 },
258 "finishedAt": {
259 "type": "string",
260 "format": "date-time",
261 "example": "2025-01-08T00:00:00.000Z"
262 },
263 "status": {
264 "type": "string",
265 "example": "READY"
266 },
267 "meta": {
268 "type": "object",
269 "properties": {
270 "origin": {
271 "type": "string",
272 "example": "API"
273 },
274 "userAgent": {
275 "type": "string"
276 }
277 }
278 },
279 "stats": {
280 "type": "object",
281 "properties": {
282 "inputBodyLen": {
283 "type": "integer",
284 "example": 2000
285 },
286 "rebootCount": {
287 "type": "integer",
288 "example": 0
289 },
290 "restartCount": {
291 "type": "integer",
292 "example": 0
293 },
294 "resurrectCount": {
295 "type": "integer",
296 "example": 0
297 },
298 "computeUnits": {
299 "type": "integer",
300 "example": 0
301 }
302 }
303 },
304 "options": {
305 "type": "object",
306 "properties": {
307 "build": {
308 "type": "string",
309 "example": "latest"
310 },
311 "timeoutSecs": {
312 "type": "integer",
313 "example": 300
314 },
315 "memoryMbytes": {
316 "type": "integer",
317 "example": 1024
318 },
319 "diskMbytes": {
320 "type": "integer",
321 "example": 2048
322 }
323 }
324 },
325 "buildId": {
326 "type": "string"
327 },
328 "defaultKeyValueStoreId": {
329 "type": "string"
330 },
331 "defaultDatasetId": {
332 "type": "string"
333 },
334 "defaultRequestQueueId": {
335 "type": "string"
336 },
337 "buildNumber": {
338 "type": "string",
339 "example": "1.0.0"
340 },
341 "containerUrl": {
342 "type": "string"
343 },
344 "usage": {
345 "type": "object",
346 "properties": {
347 "ACTOR_COMPUTE_UNITS": {
348 "type": "integer",
349 "example": 0
350 },
351 "DATASET_READS": {
352 "type": "integer",
353 "example": 0
354 },
355 "DATASET_WRITES": {
356 "type": "integer",
357 "example": 0
358 },
359 "KEY_VALUE_STORE_READS": {
360 "type": "integer",
361 "example": 0
362 },
363 "KEY_VALUE_STORE_WRITES": {
364 "type": "integer",
365 "example": 1
366 },
367 "KEY_VALUE_STORE_LISTS": {
368 "type": "integer",
369 "example": 0
370 },
371 "REQUEST_QUEUE_READS": {
372 "type": "integer",
373 "example": 0
374 },
375 "REQUEST_QUEUE_WRITES": {
376 "type": "integer",
377 "example": 0
378 },
379 "DATA_TRANSFER_INTERNAL_GBYTES": {
380 "type": "integer",
381 "example": 0
382 },
383 "DATA_TRANSFER_EXTERNAL_GBYTES": {
384 "type": "integer",
385 "example": 0
386 },
387 "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
388 "type": "integer",
389 "example": 0
390 },
391 "PROXY_SERPS": {
392 "type": "integer",
393 "example": 0
394 }
395 }
396 },
397 "usageTotalUsd": {
398 "type": "number",
399 "example": 0.00005
400 },
401 "usageUsd": {
402 "type": "object",
403 "properties": {
404 "ACTOR_COMPUTE_UNITS": {
405 "type": "integer",
406 "example": 0
407 },
408 "DATASET_READS": {
409 "type": "integer",
410 "example": 0
411 },
412 "DATASET_WRITES": {
413 "type": "integer",
414 "example": 0
415 },
416 "KEY_VALUE_STORE_READS": {
417 "type": "integer",
418 "example": 0
419 },
420 "KEY_VALUE_STORE_WRITES": {
421 "type": "number",
422 "example": 0.00005
423 },
424 "KEY_VALUE_STORE_LISTS": {
425 "type": "integer",
426 "example": 0
427 },
428 "REQUEST_QUEUE_READS": {
429 "type": "integer",
430 "example": 0
431 },
432 "REQUEST_QUEUE_WRITES": {
433 "type": "integer",
434 "example": 0
435 },
436 "DATA_TRANSFER_INTERNAL_GBYTES": {
437 "type": "integer",
438 "example": 0
439 },
440 "DATA_TRANSFER_EXTERNAL_GBYTES": {
441 "type": "integer",
442 "example": 0
443 },
444 "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
445 "type": "integer",
446 "example": 0
447 },
448 "PROXY_SERPS": {
449 "type": "integer",
450 "example": 0
451 }
452 }
453 }
454 }
455 }
456 }
457 }
458 }
459 }
460}Fast Google Sheets import and export tool OpenAPI definition
OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.
OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.
By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.
You can download the OpenAPI definitions for Google Sheets Import & Export from the options below:
If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.
You can also check out our other API clients:
Developer
Lukáš KřivkaMaintained by Community
Actor Metrics
107 monthly users
-
31 bookmarks
74% runs succeeded
5 days response time
Created in Jan 2019
Modified 20 days ago
Categories
