Github Issues Tracker avatar

Github Issues Tracker

Try for free

No credit card required

Go to Store
Github Issues Tracker

Github Issues Tracker

lukaskrivka/github-issues-to-spreadsheet
Try for free

No credit card required

Collect all open issues from GitHub repositories across multiple accounts and upload them to your spreadsheet. Make teams more productive with efficient issue tracking and never miss one.

Developer
Maintained by Community

Actor Metrics

  • 1 Monthly user

  • No reviews yet

  • 1 bookmark

  • Created in Apr 2020

  • Modified 4 years ago

You can access the Github Issues Tracker programmatically from your own applications by using the Apify API. You can also 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": "0.0",
5    "x-build-id": "s3Bm3teORkUxaxOX6"
6  },
7  "servers": [
8    {
9      "url": "https://api.apify.com/v2"
10    }
11  ],
12  "paths": {
13    "/acts/lukaskrivka~github-issues-to-spreadsheet/run-sync-get-dataset-items": {
14      "post": {
15        "operationId": "run-sync-get-dataset-items-lukaskrivka-github-issues-to-spreadsheet",
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~github-issues-to-spreadsheet/runs": {
50      "post": {
51        "operationId": "runs-sync-lukaskrivka-github-issues-to-spreadsheet",
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~github-issues-to-spreadsheet/run-sync": {
93      "post": {
94        "operationId": "run-sync-lukaskrivka-github-issues-to-spreadsheet",
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        "required": [
134          "repositories",
135          "spreadsheetId"
136        ],
137        "properties": {
138          "repositories": {
139            "title": "Repositories",
140            "type": "array",
141            "description": "From what repositories the issues will be collected",
142            "items": {
143              "type": "string"
144            }
145          },
146          "spreadsheetId": {
147            "title": "Spreadsheet id",
148            "type": "string",
149            "description": "Id of the spreadsheet where you want to upload the issues"
150          },
151          "oneSheetForAllRepositories": {
152            "title": "One sheet for all repositories",
153            "type": "boolean",
154            "description": "If true, each repository will be uploaded to a signle sheet named All issues. Can be used in combination with oneSheetPerRepository.",
155            "default": true
156          },
157          "oneSheetPerRepository": {
158            "title": "One sheet per one repository",
159            "type": "boolean",
160            "description": "If true, each repository will be uploaded to a sheet with the same name as the repository. Can be used in combination with oneSheetForAllRepositories",
161            "default": false
162          },
163          "proxyConfiguration": {
164            "title": "Proxy configuration",
165            "type": "object",
166            "description": "proxy"
167          },
168          "googleOauthStore": {
169            "title": "Google OAuth tokens store",
170            "type": "string",
171            "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",
172            "default": "google-oauth-tokens"
173          }
174        }
175      },
176      "runsResponseSchema": {
177        "type": "object",
178        "properties": {
179          "data": {
180            "type": "object",
181            "properties": {
182              "id": {
183                "type": "string"
184              },
185              "actId": {
186                "type": "string"
187              },
188              "userId": {
189                "type": "string"
190              },
191              "startedAt": {
192                "type": "string",
193                "format": "date-time",
194                "example": "2025-01-08T00:00:00.000Z"
195              },
196              "finishedAt": {
197                "type": "string",
198                "format": "date-time",
199                "example": "2025-01-08T00:00:00.000Z"
200              },
201              "status": {
202                "type": "string",
203                "example": "READY"
204              },
205              "meta": {
206                "type": "object",
207                "properties": {
208                  "origin": {
209                    "type": "string",
210                    "example": "API"
211                  },
212                  "userAgent": {
213                    "type": "string"
214                  }
215                }
216              },
217              "stats": {
218                "type": "object",
219                "properties": {
220                  "inputBodyLen": {
221                    "type": "integer",
222                    "example": 2000
223                  },
224                  "rebootCount": {
225                    "type": "integer",
226                    "example": 0
227                  },
228                  "restartCount": {
229                    "type": "integer",
230                    "example": 0
231                  },
232                  "resurrectCount": {
233                    "type": "integer",
234                    "example": 0
235                  },
236                  "computeUnits": {
237                    "type": "integer",
238                    "example": 0
239                  }
240                }
241              },
242              "options": {
243                "type": "object",
244                "properties": {
245                  "build": {
246                    "type": "string",
247                    "example": "latest"
248                  },
249                  "timeoutSecs": {
250                    "type": "integer",
251                    "example": 300
252                  },
253                  "memoryMbytes": {
254                    "type": "integer",
255                    "example": 1024
256                  },
257                  "diskMbytes": {
258                    "type": "integer",
259                    "example": 2048
260                  }
261                }
262              },
263              "buildId": {
264                "type": "string"
265              },
266              "defaultKeyValueStoreId": {
267                "type": "string"
268              },
269              "defaultDatasetId": {
270                "type": "string"
271              },
272              "defaultRequestQueueId": {
273                "type": "string"
274              },
275              "buildNumber": {
276                "type": "string",
277                "example": "1.0.0"
278              },
279              "containerUrl": {
280                "type": "string"
281              },
282              "usage": {
283                "type": "object",
284                "properties": {
285                  "ACTOR_COMPUTE_UNITS": {
286                    "type": "integer",
287                    "example": 0
288                  },
289                  "DATASET_READS": {
290                    "type": "integer",
291                    "example": 0
292                  },
293                  "DATASET_WRITES": {
294                    "type": "integer",
295                    "example": 0
296                  },
297                  "KEY_VALUE_STORE_READS": {
298                    "type": "integer",
299                    "example": 0
300                  },
301                  "KEY_VALUE_STORE_WRITES": {
302                    "type": "integer",
303                    "example": 1
304                  },
305                  "KEY_VALUE_STORE_LISTS": {
306                    "type": "integer",
307                    "example": 0
308                  },
309                  "REQUEST_QUEUE_READS": {
310                    "type": "integer",
311                    "example": 0
312                  },
313                  "REQUEST_QUEUE_WRITES": {
314                    "type": "integer",
315                    "example": 0
316                  },
317                  "DATA_TRANSFER_INTERNAL_GBYTES": {
318                    "type": "integer",
319                    "example": 0
320                  },
321                  "DATA_TRANSFER_EXTERNAL_GBYTES": {
322                    "type": "integer",
323                    "example": 0
324                  },
325                  "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
326                    "type": "integer",
327                    "example": 0
328                  },
329                  "PROXY_SERPS": {
330                    "type": "integer",
331                    "example": 0
332                  }
333                }
334              },
335              "usageTotalUsd": {
336                "type": "number",
337                "example": 0.00005
338              },
339              "usageUsd": {
340                "type": "object",
341                "properties": {
342                  "ACTOR_COMPUTE_UNITS": {
343                    "type": "integer",
344                    "example": 0
345                  },
346                  "DATASET_READS": {
347                    "type": "integer",
348                    "example": 0
349                  },
350                  "DATASET_WRITES": {
351                    "type": "integer",
352                    "example": 0
353                  },
354                  "KEY_VALUE_STORE_READS": {
355                    "type": "integer",
356                    "example": 0
357                  },
358                  "KEY_VALUE_STORE_WRITES": {
359                    "type": "number",
360                    "example": 0.00005
361                  },
362                  "KEY_VALUE_STORE_LISTS": {
363                    "type": "integer",
364                    "example": 0
365                  },
366                  "REQUEST_QUEUE_READS": {
367                    "type": "integer",
368                    "example": 0
369                  },
370                  "REQUEST_QUEUE_WRITES": {
371                    "type": "integer",
372                    "example": 0
373                  },
374                  "DATA_TRANSFER_INTERNAL_GBYTES": {
375                    "type": "integer",
376                    "example": 0
377                  },
378                  "DATA_TRANSFER_EXTERNAL_GBYTES": {
379                    "type": "integer",
380                    "example": 0
381                  },
382                  "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
383                    "type": "integer",
384                    "example": 0
385                  },
386                  "PROXY_SERPS": {
387                    "type": "integer",
388                    "example": 0
389                  }
390                }
391              }
392            }
393          }
394        }
395      }
396    }
397  }
398}

Github Issues Tracker 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 Github Issues Tracker 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: