Google Sheets API | Get Google Spreadsheet
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- 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.g...
🔥Python for Beginners - Learn Python in 1 Video • Python for Beginners -...
Donate me:
Paypal: paypal.me/fine...
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
How to Insert Data into Google Sheets using PHP
th-cam.com/video/zoufwxZjr0c/w-d-xo.html
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 ?
hello when I am in the make code software I can connect Google sheet to it in three clicks but when I want to connect Gmail to make then I have to create an API key in the Google Search console, could you help me explain why Google has two connection methods depending on its apps
in any case that's for make
because for the other software no code n8n then whether it is Google sheet or Gmail, for both you have to go through Google Search console
can you tell me in whatsapp so I can better assist you.
@finegap yes can you give me your number
hello what is the difference between this method and appscript and the import functions?
is data synchronization done in real time?
new:
Do you use no code software like make?
In fact I'm asking myself questions to try to understand the differences between custom GPT, chrome and WordPress extensions, automation software like browser automation studio and make
I had an idea of creating an SEO and image editing but I don't know how to go about it I thought of several solutions either with make or by creating a Chrome or WordPress plugin or by using a existing plugin but I don't think it exists to do what I want or even with a custom GPT
seo:
OK and what do you think about rank math?
I understand that this extension allows me to scan my pages and find the keywords to replace, from my back end, have I understood correctly?
And I also understood that this does not allow me to ask it to scan my entire website?
I mean if I understood correctly it scans the pages but one by one and I have to do everything by hand?
This is why I wondered if I could not create an extension to which I would give the URL of my website and have it scan all the pages and tell me which keywords to replace
And I even wondered if I wouldn't be able to make a robot with custom GPT or even with no code software like make in the case where an extension wouldn't be able to allow me to do it, does this idea seem good to you?
do you also create chrome or WordPress extensions?
I'm asking you this question because I'm trying to understand what I could do with custom GPT, could I do more with a chrome WordPress extension? Does it exist or not and finally what more can I do with it? make compared to its other methods
Amazon, jungle scout
I would like to use the jungle scout api but at the moment I am looking into the subject of artificial intelligence and I realized that there are several ways to use APIs and so I would like to try first to understand what is the difference between using the jungle scout api in a dent custom gpt action and I realized that I can also use the JS api in a make scenario
Could you tell me what the difference is, what could I get, using either of these two methods?
And also with the Amazon API?
I understand that Amazon has several APIs?
Do you also sell on several marketplaces?
could you give me your opinion
could I send you an email
you can read the doc for difference because I don't remember now, its long ago
yes synchronization is done in real time.
hello I'm writing a new message to caramel response on my old messages are deleted by TH-cam, in fact I'm not sure I have understood what appscript is, does it allow me to connect an API in Google sheet? but nothing more?
is it better to code than to use the existing module that allows me to connect an API?
yes you can follow this for inserting data but for getting it would ALSO help you
th-cam.com/video/zoufwxZjr0c/w-d-xo.htmlsi=w1Tp3ZblD79f2sKx
@finegap
I have a database, a product catalog, which I created on Google sheet
I would like to synchronize my listings with woocommerce
there are people who use make
there are other people who install a Google sheet plugin on WordPress
What I would have liked is not to install the plugin and so I was wondering if Google sheet has an option to integrate the woo API?
otherwise there is perhaps another possibility the Google sheet API connector extension?
That's what would help me because I don't know anything about code,
Otherwise do you have to use script?
@@chrisder1814 yes this API will connect with Google sheet
@finegap this API? I'm not sure I understand what you mean, are you talking about woo's API? that I can connect to Google sheet? OK but how ?
how can you give me a link, if it exists, so that I can download templates, like that I can understand more easily what script allows me to do
Is it on gitub that I can download template apps script?
and are you using api connector extension?
@@chrisder1814 now tell me what's the main issue
hello Do you use the APIs when you create GPTs? do you also use automation software?
I used automation softwares when needed. but in code we can enable cron jobs
@@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 ?
@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 ?
hello could you help me understand how to integrate APIs into other applications
hey, yes you can contact me directly through Whatsapp
@@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
@@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
hello I wrote to you on August 12
text me on whatsapp please in the description.
Thank you very much!!
don't forget to subscribe us, thanks
nice video sir!!thanks
Most welcome
hello Do you use custom GPT with action, Amazon API
no but I can integrate.
@@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?
@@chrisder1814 Amazon which API?
@@finegap Why are you asking me which API? Do you mean that Amazon has several APIs?
@@chrisder1814 yes
when trying to implement using C# , it is not working..Can anybody help me?
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.
yes check my video how to insert data in sheet php on this same playlist, you will get the idea
it gave me a json but not the API key i need within my javascript code 😕
API key is not exist in json. you need to copy from setting.
Where can i get the link to that JSON file to search in browser?
which json are you talking?
@@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.
@@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
Thank you bro
Your are welcome & don't forget to subscribe me :)
@@finegap okau
This is the error : Error creating credential from JSON or JSON parameters. Unrecognized credential type
error is mentioned you just need to make sure credentials and just search on google
I don't fully understand what I'm watching, but great video nonetheless
Are you developer
@@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
@@adamengbring7716 watch my video how to insert data into google sheet, than you will get the idea.
Nice Video,
Is there any way, where we can create google sheet through API
Yes there must be a way to create i will read and send link to you.
@@finegap Thanks !!
@@naveedrao3886 You can create sheet by this API
developers.google.com/sheets/api/guides/create
Excellent Work
How to get call this api in react js application
you can check google calender documentation if they provide, thanks
you can check google calender documentation if they provide, thanks
hello Do you use GPTs with APIs?
Yes I do
@@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?
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?
@@cgc2300 google api used for its own purpose
@finegap I don't understand what you mean