Actor picture

Google Sheets Import & Export

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 perfect for importing data from scraping.

No credit card required

Author's avatarLukáš Křivka
  • Modified
  • Users394
  • Runs923,404
Actor picture

Google Sheets Import & Export

To run the code examples, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token. For a more detailed explanation, please read about running actors via the API in Apify Docs.

const { ApifyClient } = require('apify-client');

// Initialize the ApifyClient with API token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare actor input
const input = {
    "transformFunction": `// Uncomment this code only if you don't use "Deduplicate by field" or "Deduplicate by equality"
        // This code behaves as if there was no transform function
        /*({ spreadsheetData, datasetData }) => {
            return spreadsheetData.concat(datasetData);
        }*/`
};

(async () => {
    // Run the actor and wait for it to finish
    const run = await client.actor("lukaskrivka/google-sheets").call(input);

    // Fetch and print actor results from the run's dataset (if any)
    console.log('Results from dataset');
    const { items } = await client.dataset(run.defaultDatasetId).listItems();
    items.forEach((item) => {
        console.dir(item);
    });
})();