Google Sheets API | Get Google Spreadsheet

Подписаться 7 тыс.

Просмотров 100 тыс.

50% 1

Hi, friends In this video I will show how you can Get Google Spreadsheet by API. If you do not know how to create a Google Sheets API watch my previous video link below.
Create Google API | Sheets API
• How to Create Google A...
Get Google Sheets in PHP
• Get Google Sheets in PHP
Wherefrom Create API
console.cloud.google.com/
🔥Python for Beginners - Learn Python in 1 Video • Python for Beginners -...
Donate me:
Paypal: paypal.me/finegap?country.x=A...
Binance Pay ID: 253333352
==============================
Follow us Links:
Instagram: / fine_gap
Facebook: / finegap
Whatsapp: +923041100028
================================================
Disclaimer
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research, Fair use is a use permitted by copyright statute that might otherwise be infringing, Non-profit, educational, or personal use tips the balance in favor of fair use.
Some photos in the video are free-to-use photos downloaded from pixabay.com. The picture used in this video is protected by the Fair Use Law, section 107 used for commentary, criticism, news reporting, or education for transformative use.
The video Has been made for available informational and educational purposes only, Everything in this video is based on information we learned from online resources, our own experience, and books we have read.
#sheetapi #googleapi #getdata

Хобби

Опубликовано:

15 июн 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 63

@finegap Год назад

How to Insert Data into Google Sheets using PHP ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zoufwxZjr0c.html

@SD-rg5mj 21 день назад

je relis tout notre conversation mais je me demande finalement si tu as bien compris ce que je voulais faire j'ai refait ton tuto et maintenant la question que je me pose c'est est-ce qu'il serait possible en associant dans make les API de chatgpt et canva et WordPress pour que ça me scanne les images présentent sur ma boutique est que ça me les remplace par des images plus vendeuses Et si ce n'est pas possible alors j'ai pensé à une seconde méthode J'ai fait un catalogue de produits sur Google sheet puis je l'ai emporté dans ma boutique WordPress Dans ce catalogue il y a les images Donc je me suis dit que peut-être la seconde méthode et peut-être la seule possible serait de faire un changement d'image automatique (grâce à make et aux api) directement dans mon Google sheet puis importer celui-ci dans ma boutique WordPress ?

@ayeshabhutto5648 2 года назад

Excellent Work

@businessstart1810 Год назад

Thank you very much!!

@finegap Год назад

don't forget to subscribe us, thanks

@user-mm3vt8yb7q 10 месяцев назад

nice video sir!!thanks

@finegap 10 месяцев назад

Most welcome

@faisalzubair2612 Год назад

when trying to implement using C# , it is not working..Can anybody help me?

@ptitbass Год назад

Can we call the GET request directly in the browser? It seem to work inside Try Window but not outside.. i also added my key in the URL but still get a code 403.

@finegap Год назад

yes check my video how to insert data in sheet php on this same playlist, you will get the idea

@kamisama1712 3 месяца назад

Thank you bro

@finegap 3 месяца назад

Your are welcome & don't forget to subscribe me :)

@kamisama1712 3 месяца назад

@@finegap okau

@naveedrao3886 3 года назад

Nice Video, Is there any way, where we can create google sheet through API

@finegap 3 года назад

Yes there must be a way to create i will read and send link to you.

@naveedrao3886 3 года назад

@@finegap Thanks !!

@finegap 3 года назад

@@naveedrao3886 You can create sheet by this API developers.google.com/sheets/api/guides/create

@videosforyou4228 2 года назад

Where can i get the link to that JSON file to search in browser?

@finegap 2 года назад

which json are you talking?

@videosforyou4228 2 года назад

@@finegap the preview that it is showing on the bottom right. Basically i need a link when i see the sheet data in JSON format when searched in browser.

@finegap 2 года назад

@@videosforyou4228 if you want to get this json according to your need, you need to get data in php or some other language by the way theres another video to get data from google sheet in php

@SD-rg5mj 22 дня назад

hello Do you use the APIs when you create GPTs? do you also use automation software?

@finegap 21 день назад

I used automation softwares when needed. but in code we can enable cron jobs

@SD-rg5mj 21 день назад

@@finegap I'm not shure to understand could you give me a tutorial à propos des gpts est-ce qu'il serait possible en associant dans make les API de chatgpt et canva et WordPress pour que ça me scanne les images présentent sur ma boutique est que ça me les remplace par des images plus vendeuses Et si ce n'est pas possible alors j'ai pensé à une seconde méthode J'ai fait un catalogue de produits sur Google sheet puis je l'ai emporté dans ma boutique WordPress Dans ce catalogue il y a les images Donc je me suis dit que peut-être la seconde méthode et peut-être la seule possible serait de faire un changement d'image automatique (grâce à make et aux api) directement dans mon Google sheet puis importer celui-ci dans ma boutique WordPress ?

@SD-rg5mj 21 день назад

@finegap could you recommend a tutorial that I could read or watch to better understand what you can say and also I would like to ask you would it be possible by combining in make the chatgpt and canva and WordPress so that it scans the images on my store and replaces them with more commercially available images And if that's not possible then I thought of a second method I made a product catalog on Google sheet then took it to my WordPress store In this catalog there are the images So I told myself that perhaps the second method and perhaps the only possible one would be to do an automatic image change (thanks to make and the APIs) directly in my Google sheet then import it into my WordPress store ?

@faisalzubair2612 Год назад

This is the error : Error creating credential from JSON or JSON parameters. Unrecognized credential type

@finegap Год назад

error is mentioned you just need to make sure credentials and just search on google

@AdsPowerAula Месяц назад

it gave me a json but not the API key i need within my javascript code 😕

@finegap Месяц назад

API key is not exist in json. you need to copy from setting.

@chrisder1814 5 дней назад

hello could you help me understand how to integrate APIs into other applications

@finegap 4 дня назад

hey, yes you can contact me directly through Whatsapp

@chrisder1814 3 дня назад

@@finegap I made a product catalog with Google sheet and the product title and description sheets were made with chatgpt, By following one of your tutorials which dates back 1 or 2 years. In this Google sheet catalog there are around sixty products, for the moment, my idea is to use the API of a photo editing software to remove all the wallpapers from each of the photos without me doing anything at all, with a make scenario. So I would like to know if it is possible and then if my idea of using a make scenario is good, is it the best? and above all, is it feasible? And then I thought the same thing regarding SEO automation

@finegap 3 дня назад

@@chrisder1814 I don't understand your concern quite clear, can explain more and why do you need Google sheet for it, or maybe you can contact me via WhatsApp

@baxtables Год назад

How to get call this api in react js application

@finegap Год назад

you can check google calender documentation if they provide, thanks

@finegap Год назад

you can check google calender documentation if they provide, thanks

@adamengbring7716 Год назад

I don't fully understand what I'm watching, but great video nonetheless

@finegap Год назад

Are you developer

@adamengbring7716 Год назад

@@finegap No. But trying to understand to incorporate live spreadsheet results into a webpage. Gave up on using an API and have been running manually

@finegap Год назад

@@adamengbring7716 watch my video how to insert data into google sheet, than you will get the idea.

@chrisder1814 14 дней назад

hello Do you use custom GPT with action, Amazon API

@finegap 13 дней назад

no but I can integrate.

@chrisder1814 13 дней назад

@@finegap I don't understand what you mean by integrating and I wonder what the effect would be if I added the Amazon API in a custom gpt?

@finegap 13 дней назад

@@chrisder1814 Amazon which API?

@chrisder1814 13 дней назад

@@finegap Why are you asking me which API? Do you mean that Amazon has several APIs?

@finegap 13 дней назад

@@chrisder1814 yes

@cgc2300 2 месяца назад

hello Do you use GPTs with APIs?

@finegap 2 месяца назад

Yes I do

@cgc2300 2 месяца назад

@@finegap je viens de prendre l'abonnement et je suis déçu en tout cas je galère bien pour essayer de comprendre comment l'utiliser pour arriver à mes fins quel est l'intérêt et comment utiliser correctement les knowledges et actions je veux dire ce que on attend des IA c'est que ça nous serve de prof génial , d'expert ? que l'on est 1000 experts sur 1000 sujets différents et tout ça dans un ordi ? mais je suis déçu , enfin je pense que je l'utilise mal, je regarde plein de tutos sur différents sujets et je donne le transcript à gpt en lui demandant de répondre aux questions que je pourrais poser au youtubeur ou alors de me refaire les tutos sur ces différents sujets en lui demandant de s'adresser à un débutant et j'aurais pensé que ces tutos auraient été plus détailler que lorsque je le fais avec le 3.5 ou copilot mais ça reste autant basique et quand je lui demande comment est-ce que je peux créer un GPT pour avoir des résultats plus probants il ne sait pas je ne doute pas qu'avec des intelligences humaines j'aurais des meilleurs résultats et aussi je pense qu'en créant un GPT et donc en utilisant les parties knowledges et actions j'aurais de meilleur résultat ? c'est ce qui le rend plus pertinent , c'est ça qui va faire que j'aurai des tutos plus détaillé ? mais si je lui constitue une petite base de données constituée d'information moisies et pas mise à jour , je risque d'obtenir des tutos flingués?

@cgc2300 2 месяца назад

could you explain to me what is the difference between using APIs in Google sheet as you do here and using them in GPTs I'm asking you this question because I can't understand at all what APIs allow you to do in GPTs could you give me some examples so that I can understand? I would like to sell products on eBay and I have software for eBay SEO called zik analytic could you tell me what I could do with the API of this software in a GPT?

@finegap 2 месяца назад

@@cgc2300 google api used for its own purpose

@cgc2300 2 месяца назад

@finegap I don't understand what you mean