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

108

Runs succeeded

84%

Response time

22 days

Last modified

11 days ago

Automation

Open source

Integrations

Back to issues Create new issue

Report columns are alphabetized, I'd like them in original order

Closed

RPM Select (nknmcm) opened this issue

Hi there! When a report is populated in my Google Sheet, the Columns are reordered and sorted A to Z. I would like to maintain the original order of columns that is found in the source report. Is this possible?

Lukáš Křivka (lukaskrivka)

Hello,

There are 2 options for this in the input so choose which one works the best for you. You can either define the order in the input directly or just respect the order you have in the sheet already.

RPM Select (nknmcm)

Thank you for your help Lukas. When I try this, it's still not working. I'm guessing it's because I'm integrating the Legacy PhantomJS Crawler actor with this Google Sheets Import & Export actor - maybe the Legacy PhantomJS Crawler is alphabetizing the columns, then turning on the "Keep column order from sheet" setting in the Google Sheets Import & Export actor just maintains the column order passed on from the Legacy PhantomJS Crawler. Do you know of any way to fix that?

Lukáš Křivka (lukaskrivka)

You would have to share the specific run where this happens. You can send the run ID to lukas@apify.com to keep it private

RPM Select (nknmcm)

Hi Lukas, I sent you an email with this info.

Lukáš Křivka (lukaskrivka)

Hello,

I'm sorry I didn't get to your topic, the runs are sadly removed now. Do you have any other recent case? I will close this for now but please follow up if you are still working on it.

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

252

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

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á

Pinecone Integration

apify/pinecone-integration

This integration transfers data from Apify Actors to a Pinecone and is a good starting point for a question-answering, search, or RAG use case.

Apify

313

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

Login Session

pocesar/login-session

Get localStorage, sessionStorage and cookies from logins for usage in other actors.

Paulo Cesar

377

FTP file uploader

petr_cermak/ftp-upload

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

Petr Cermak

MileFinderLatam

alanmatheus187/latam-novo

MileFinderLatam é um actor do Apify que busca milhas e pontos da LATAM. Perfeito para viajantes, coleta dados de passagens e fidelidade, otimizando suas viagens.