{"uid":"cap_7MefVxIvilCL7QT_VCK_0","slug":"google-sheets-import-export-via-apify-stableapify-dev-fda10e49","name":"Google Sheets Import & Export via Apify (stableapify.dev)","description":"Start the \"Google Sheets Import & Export\" Apify actor (lukaskrivka/google-sheets). 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 pe…","url":"https://stableapify.dev/api/actors/lukaskrivka/google-sheets/call","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"input":{"type":"object","required":["mode","limit","offset","publicSpreadsheet","tokensStore"],"properties":{"mode":{"enum":["append","replace","modify","read","load backup"],"type":"string","default":"append","description":"What should the actor do"},"limit":{"type":"integer","default":250000,"maximum":9007199254740991,"minimum":0,"description":"Number of items to take from the dataset. The default is 250000."},"range":{"type":"string","description":"Range of the spreadsheet in A1 notation where the actor should operate. Default is the first sheet."},"offset":{"type":"integer","default":0,"maximum":9007199254740991,"minimum":0,"description":"Number of items to skip from the dataset. Default is 0."},"rawData":{"type":"object","description":"Raw data JSON array. Can be array of arrays for direct row import or arrays of objects.","propertyNames":{"type":"string"},"additionalProperties":{}},"datasetId":{"type":"string","description":"Dataset ID where the new data will be loaded from"},"backupStore":{"type":"string","description":"Id of the key-value store where the backup you want to load is located. Can only be used if mode is 'load-backup'"},"tokensStore":{"type":"string","default":"google-oauth-tokens","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"},"columnsOrder":{"type":"array","items":{"type":"string"},"description":"Array of keys. First sorts the columns by provided keys. The rest is sorted alphabetically."},"createBackup":{"type":"boolean","description":"Old rows from your spreadsheet will be saved to the default key-value store before importing new rows."},"spreadsheetId":{"type":"string","description":"Id of the spreadsheet from where the old data will be loaded"},"googleCredentials":{"type":"object","description":"If you want to use this actor locally or with your own version, you have to provide your own credentials. Check actor readme for more information.","propertyNames":{"type":"string"},"additionalProperties":{}},"publicSpreadsheet":{"type":"boolean","default":false,"description":"If checked, you don't need to authorize. You have to publish your spreadsheet and it works only in read mode"},"transformFunction":{"type":"string","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'"},"deduplicateByField":{"type":"string","description":"Items will be deduplicated by a value of this field. Cannot be used together with 'Deduplicate by equality' or 'Transform function'."},"keepSheetColumnOrder":{"type":"boolean","description":"If true, keeps the order of columns as they are in the sheet. If there is no sheet data yet, this does nothing."},"deduplicateByEquality":{"type":"boolean","description":"Items will be deduplicated if they are the same. Cannot be used together with 'Deduplicate by field' or 'Transform function'."},"sheetId.eFPUdxsL7X2cdSvE2":{"type":"string","description":"Spreadsheet from where the old data will be loaded"},"oAuthAccount.eFPUdxsL7X2cdSvE2":{"type":"string","description":"Google Account Id"}},"description":"Normalized actor input. See field descriptions for the simplified shape; native Apify input also accepted (passed through).","additionalProperties":{}},"options":{"type":"object","properties":{"build":{"type":"string","maxLength":100,"minLength":1},"memory":{"type":"integer","maximum":32768,"minimum":128},"maxItems":{"type":"integer","maximum":100000,"minimum":1}},"description":"Optional Apify run options.","additionalProperties":false}}},"responseSchema":null,"example":{"request":{"input":{"username":"neal-mohan","includeEmail":false},"options":{"memory":256,"maxItems":100}},"response":{"run":{"id":"JRzhCHnC1eLpURA2S","status":"READY","actorId":"uCbMx3aLeKZLuDKvH","startedAt":"2026-06-16T17:44:59.629Z","usageTotalUsd":0.00005,"defaultDatasetId":"Huj7s5180scFRjlrg"},"token":"eyJhbGciOiJIUzI1NiJ9.eyJydW5JZCI6IkpSemhDSG5DMWVMcFVSQTJTIiwiYWN0b3JJZCI6Imx1a2Fza3JpdmthL2dvb2dsZS1zaGVldHMiLCJkZWZhdWx0RGF0YXNldElkIjoiSHVqN3M1MTgwc2NGUmpscmciLCJ3IjoiMHg5Y2M0MmYzZDkyNDViODY3YWNjY2Q2MzBiNDNmOTA2YzE2NjViMTc2IiwiaWF0IjoxNzgxNjMxODk5LCJleHAiOjE3ODQyMjM4OTl9.-oIqdBfXKO8NA9rfk6NJfoGe8bgNpULlDf8sOzuUjHw"}},"exampleRequest":{"input":{"username":"neal-mohan","includeEmail":false},"options":{"memory":256,"maxItems":100}},"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"settled","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_XDWKQDWBuPXgP_mfdhh_p","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Starts the lukaskrivka/google-sheets Apify actor to import data from datasets or JSON files into Google Sheets, or export and programmatically process spreadsheet data.","exampleAgentPrompt":"Take the results from my Apify dataset (ID: Huj7s5180scFRjlrg) and import them into my Google Sheet at https://docs.google.com/spreadsheets/d/my-sheet-id, using 256MB memory and capping at 100 items.","exampleUseCases":[{"title":"Push scrape results to spreadsheet","prompt":"I just ran a LinkedIn scraper and have the dataset ID ready — can you import those results into my Google Sheet at https://docs.google.com/spreadsheets/d/1aBcD123 using 512MB memory and up to 500 items?"},{"title":"Automate JSON data ingestion to Sheets","prompt":"I have a JSON file at https://myserver.com/data.json with product listings — please import it into my Google Sheets document so my team can review it, limit it to 200 rows and use 256MB memory."},{"title":"Sync daily scraper output to reporting sheet","prompt":"Every time my Apify actor finishes, I want the output dataset automatically loaded into our reporting Google Sheet at https://docs.google.com/spreadsheets/d/xYz789 — can you trigger that import now with the dataset ID abc123 and 256MB memory?"}],"resultDescription":"Returns an actor run object containing the run ID, status (e.g. READY), actor ID, start timestamp, estimated usage cost in USD, default dataset ID, and a JWT token used to poll results from the run's dataset via a sibling endpoint.","failureModes":["Invalid or inaccessible Google Sheets URL — actor fails to write, returns error status","Dataset ID not found or empty — actor starts but produces no rows","Insufficient memory allocation causes actor to crash mid-run","Google Sheets permissions not granted to the actor's service account — write fails","Payment failure (x402) if wallet has insufficient USDC balance","Actor run times out for very large datasets exceeding memory limits"],"whenToPreferThis":"Choose this endpoint when you need a simple, pay-per-call way to move Apify dataset or JSON data into Google Sheets without setting up OAuth credentials or wrestling with the official Google Sheets API quota limits. It is especially useful for agents that already run Apify actors and want to pipe results directly into a spreadsheet for human review or downstream processing.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T18:51:27.454Z","isFirstParty":false}