![Google Sheets Import & Export avatar](https://images.apifyusercontent.com/lIqn6WtklNVhD4_ra95N7W98B9VRYkEz0cwDcAgxXzM/rs:fill:250:250/aHR0cHM6Ly9hcGlmeS1pbWFnZS11cGxvYWRzLXByb2QuczMuYW1hem9uYXdzLmNvbS91Q2JNeDNhTGVLWkx1REt2SC9TcjY0SHBpUGtUM2NoOWVGdy1nb29nbGVfc2hlZXRzLnBuZw.webp)
Google Sheets Import & Export
Try for free
No credit card required
View all Actors![Google Sheets Import & Export](https://images.apifyusercontent.com/lIqn6WtklNVhD4_ra95N7W98B9VRYkEz0cwDcAgxXzM/rs:fill:250:250/aHR0cHM6Ly9hcGlmeS1pbWFnZS11cGxvYWRzLXByb2QuczMuYW1hem9uYXdzLmNvbS91Q2JNeDNhTGVLWkx1REt2SC9TcjY0SHBpUGtUM2NoOWVGdy1nb29nbGVfc2hlZXRzLnBuZw.webp)
![Google Sheets Import & Export](https://images.apifyusercontent.com/lIqn6WtklNVhD4_ra95N7W98B9VRYkEz0cwDcAgxXzM/rs:fill:250:250/aHR0cHM6Ly9hcGlmeS1pbWFnZS11cGxvYWRzLXByb2QuczMuYW1hem9uYXdzLmNvbS91Q2JNeDNhTGVLWkx1REt2SC9TcjY0SHBpUGtUM2NoOWVGdy1nb29nbGVfc2hlZXRzLnBuZw.webp)
Google Sheets Import & Export
lukaskrivka/google-sheets
Try for free
No credit card required
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.
Do you want to learn more about this Actor?
Get a demoThe code examples below show how to run the Actor and get its results. To run the code, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token, which you can find under Settings > Integrations in Apify Console. Learn more
1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4client = ApifyClient("<YOUR_API_TOKEN>")
5
6# Prepare the Actor input
7run_input = { "transformFunction": """// Uncomment this code only if you don't use \"Deduplicate by field\" or \"Deduplicate by equality\"
8// This code behaves as if there was no transform function
9/*({ spreadsheetData, datasetData }) => {
10 return spreadsheetData.concat(datasetData);
11}*/""" }
12
13# Run the Actor and wait for it to finish
14run = client.actor("lukaskrivka/google-sheets").call(run_input=run_input)
15
16# Fetch and print Actor results from the run's dataset (if there are any)
17print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
18for item in client.dataset(run["defaultDatasetId"]).iterate_items():
19 print(item)
20
21# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start
Developer
Maintained by Apify
Actor metrics
- 45 monthly users
- 24 stars
- 97.1% runs succeeded
- 2.5 days response time
- Created in Jan 2019
- Modified 3 months ago
Categories