Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
Colombo
Kaduwela - Two Storey House for Sale
dilrasan
Updated:
Thursday at 2:23 PM
Ad icon
Wechat qr verification
Pawan2005
Updated:
Thursday at 1:28 AM
🚀 GOOGLE AI PRO 18 MONTHS ACTIVATION 🚀
sayuru bandara
Updated:
Wednesday at 5:34 PM
Pure VPN - Up to 27 Months
vgp
Updated:
Jun 5, 2026
එක පැකේජ් එකයි මාසෙටම Unlimited Internet. තාමත් DATA CARD දාන්න සල්ලි වියදම් කරනවද? අඩුම මිලට අපෙන්.
sayuru bandara
Updated:
Jun 2, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Talk!
Accessing Google Spreadsheet Data using Python
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="csharp" data-source="post: 26723051" data-attributes="member: 560481"><p><h3><span style="font-size: 18px">If you’re building a simple internal app and you might probably be thinking that ‘I’m going to need a database now right!’. Well, Not so fast!</span></h3><p><span style="font-size: 18px"><a href="https://1.bp.blogspot.com/-PM5jAF6kCFI/YPgDqFtcSYI/AAAAAAAABds/VuRv0QhoUQYEHCQgqsrrBiH4JN4f8T4rACLcBGAsYHQ/s670/1_4Dc9yq-MSZgRbIrq_2lZZw%2B%25281%2529.png" target="_blank"><img src="https://1.bp.blogspot.com/-PM5jAF6kCFI/YPgDqFtcSYI/AAAAAAAABds/VuRv0QhoUQYEHCQgqsrrBiH4JN4f8T4rACLcBGAsYHQ/s16000/1_4Dc9yq-MSZgRbIrq_2lZZw%2B%25281%2529.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a></span></p><p><span style="font-size: 18px"></span></p><p><span style="font-size: 18px">As you all are familiar with importing, exporting and manipulating comma separate files (CSV) using Python, Hereby in this article I’m going to show you the step-by-step guide to access Google Spreadsheets on the cloud using Python.</span></p><p><span style="font-size: 18px">As the very first thing, go to Google API Manager by simply googling it and go to <a href="https://console.developers.google.com/" target="_blank">https://console.developers.google.com/</a></span></p><p><span style="font-size: 18px"><img src="https://cdn-images-1.medium.com/max/720/1*Izo9A50RHKjXGsPO-x0Hxw.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></span></p><p><span style="font-size: 18px"><a href="https://console.developers.google.com/" target="_blank">https://console.developers.google.com/</a></span></p><p><span style="font-size: 18px">To kick things off first create a new project.</span></p><p><span style="font-size: 18px"><img src="https://cdn-images-1.medium.com/max/720/1*vKGuojn7KZV7HAvPY95_DA.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></span></p><p><span style="font-size: 18px">Figure 1.0: Creating a new Project</span></p><p><span style="font-size: 18px">I’ll name my project as ‘Telemedicine’ since we will be working with a spreadsheet that includes all the tweets related to Telemedicine hashtags which I extracted earlier<strong><em> (</em></strong><a href="https://www.jayasekara.blog/2021/07/extracting-twitter-data-pre-processing-and-sentiment-analysis.html" target="_blank"><strong><em>Click here to see how I extracted tweets using hashtags</em></strong></a><strong><em>)</em></strong>. Define a suitable project name according to your dataset on the cloud then click <strong>CREATE</strong> to initiate the project. (You don’t have to worry about the<strong> Location* </strong>below the project name)</span></p><p><span style="font-size: 18px"></span></p><p><a href="https://www.jayasekara.blog/2021/07/accessing-google-spreadsheet-data-using-python.html" target="_blank"><span style="font-size: 18px">Read full article here</span></a></p></blockquote><p></p>
[QUOTE="csharp, post: 26723051, member: 560481"] [HEADING=2][SIZE=5]If you’re building a simple internal app and you might probably be thinking that ‘I’m going to need a database now right!’. Well, Not so fast![/SIZE][/HEADING] [SIZE=5][URL='https://1.bp.blogspot.com/-PM5jAF6kCFI/YPgDqFtcSYI/AAAAAAAABds/VuRv0QhoUQYEHCQgqsrrBiH4JN4f8T4rACLcBGAsYHQ/s670/1_4Dc9yq-MSZgRbIrq_2lZZw%2B%25281%2529.png'][IMG]https://1.bp.blogspot.com/-PM5jAF6kCFI/YPgDqFtcSYI/AAAAAAAABds/VuRv0QhoUQYEHCQgqsrrBiH4JN4f8T4rACLcBGAsYHQ/s16000/1_4Dc9yq-MSZgRbIrq_2lZZw%2B%25281%2529.png[/IMG][/URL] As you all are familiar with importing, exporting and manipulating comma separate files (CSV) using Python, Hereby in this article I’m going to show you the step-by-step guide to access Google Spreadsheets on the cloud using Python. As the very first thing, go to Google API Manager by simply googling it and go to [URL]https://console.developers.google.com/[/URL] [IMG]https://cdn-images-1.medium.com/max/720/1*Izo9A50RHKjXGsPO-x0Hxw.png[/IMG] [URL]https://console.developers.google.com/[/URL] To kick things off first create a new project. [IMG]https://cdn-images-1.medium.com/max/720/1*vKGuojn7KZV7HAvPY95_DA.png[/IMG] Figure 1.0: Creating a new Project I’ll name my project as ‘Telemedicine’ since we will be working with a spreadsheet that includes all the tweets related to Telemedicine hashtags which I extracted earlier[B][I] ([/I][/B][URL='https://www.jayasekara.blog/2021/07/extracting-twitter-data-pre-processing-and-sentiment-analysis.html'][B][I]Click here to see how I extracted tweets using hashtags[/I][/B][/URL][B][I])[/I][/B]. Define a suitable project name according to your dataset on the cloud then click [B]CREATE[/B] to initiate the project. (You don’t have to worry about the[B] Location* [/B]below the project name) [/SIZE] [URL='https://www.jayasekara.blog/2021/07/accessing-google-spreadsheet-data-using-python.html'][SIZE=5]Read full article here[/SIZE][/URL] [/QUOTE]
Insert quotes…
Verification
Winadiyakata thappara keeyak tibeda?
Post reply
Top
Bottom