Pricing

Pay per usage

Go to Store

Google Sheets Import & Export

Try for free

Developed by

Lukáš Křivka

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.

5.0 (1)

Pricing

Pay per usage

Monthly users

123

Runs succeeded

83%

Response time

1.6 days

Last modified

15 days ago

Automation

Open source

Integrations

Back to issues Create new issue

I got an exception error although it worked in intergration with another actor before

Closed

Sameh George Jarour (sameh.jarour) opened this issue

2025-01-28T03:31:36.855Z TypeError: Cannot read properties of undefined (reading 'length') 2025-01-28T03:31:36.856Z at module.exports (/usr/src/app/src/upload.js:6:45) 2025-01-28T03:31:36.857Z at /usr/src/app/src/main.js:177:11 2025-01-28T03:31:36.857Z at processTicksAndRejections (node:internal/process/task_queues:96:5) 2025-01-28T03:31:36.858Z at async run (/usr/src/app/node_modules/apify/build/actor.js:182:13)

Lukáš Křivka (lukaskrivka)

Thanks for the report.

There are 2 issues:

We don't support the new payload format for integration
We don't gracefully handle if we think we have empty dataset

Both should be simple fixes, will look into it asap

Lukáš Křivka (lukaskrivka)

Actually, there was no bug, you haven't chosen any mode. I updated the input to have 'append' mode as default so now the resurrected run works.

Add comment

Pricing

Pricing model

Pay per usage

This Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

This actor will monitor the google sheets file and do actions correspondingly.

Tin Duong

Google Drive

onidivo/google-drive

Transfer files between Apify's key-value stores and Google Drive.

Onidivo Technologies

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

253

eSIMDB Country Scraper

muhammetakkurtt/esimdb-country-scraper

This Apify actor collects eSIM data plans for specific countries. It collects comprehensive data such as provider information, plan details and pricing from esimdb.com and saves it in the Apify dataset. Users can easily retrieve relevant eSIM data by selecting a country.

Muhammet Akkurt

Username Availability Checker 🔍

easyapi/username-availability-checker

Check username availability across 80+ platforms including Twitter, Instagram, YouTube, GitHub, and more! Get instant results with platform logos, URLs, and availability status. Essential tool for brand research, social media management, and digital presence optimization. 🔍

EasyApi

FTP file uploader

petr_cermak/ftp-upload

Performs a simple upload of an array of files to an FTP.

Petr Cermak

Toggl Invoice Download

katerinahronik/toggl-invoice-download

Save time by automating monthly invoice downloads with web robotic process automation. Download invoices from Toggl and optionally upload the invoice to Dropbox and send an email notification.

Kateřina Hroníková

Diff Datasets

pocesar/diff-datasets

Take one dataset on Apify platform, compare it to another, and output the missing ones. This can also be used to output only changed items, using a compound key

Paulo Cesar

Json To Excel

zuzka/json-to-excel

Convert your json into a tabular form, such as CSV, Excel or HTML table fast and easy.

Zuzka Pelechová

Power Webhook Integration

pocesar/run-webhook-digest

Allows you to provide multiple HTTP endpoints, that receive a more complete JSON from the run, and allow you to hit those endpoints using a proxy, and enable you to do conditional webhook calls with some lines of Javascript code and you can link/chain one actor to another

Paulo Cesar