Google Sheets API | Get Google Spreadsheet

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ม.ค. 2025

ความคิดเห็น • 82

  • @finegap
    @finegap  2 ปีที่แล้ว +2

    How to Insert Data into Google Sheets using PHP
    th-cam.com/video/zoufwxZjr0c/w-d-xo.html

    • @SD-rg5mj
      @SD-rg5mj 6 หลายเดือนก่อน

      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 ?

  • @chrisder1814
    @chrisder1814 5 หลายเดือนก่อน

    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

    • @finegap
      @finegap  5 หลายเดือนก่อน

      can you tell me in whatsapp so I can better assist you.

    • @chrisder1814
      @chrisder1814 5 หลายเดือนก่อน

      @finegap yes can you give me your number

  • @SD-rg5mj
    @SD-rg5mj 6 หลายเดือนก่อน

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

    • @finegap
      @finegap  6 หลายเดือนก่อน

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

    • @SD-rg5mj
      @SD-rg5mj 6 หลายเดือนก่อน

      @@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 ?

  • @chrisder1814
    @chrisder1814 5 หลายเดือนก่อน

    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?

    • @finegap
      @finegap  5 หลายเดือนก่อน

      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

    • @chrisder1814
      @chrisder1814 5 หลายเดือนก่อน

      @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?

    • @finegap
      @finegap  5 หลายเดือนก่อน

      @@chrisder1814 yes this API will connect with Google sheet

    • @chrisder1814
      @chrisder1814 5 หลายเดือนก่อน

      @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?

    • @finegap
      @finegap  5 หลายเดือนก่อน

      @@chrisder1814 now tell me what's the main issue

  • @videosforyou4228
    @videosforyou4228 3 ปีที่แล้ว +2

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

    • @finegap
      @finegap  3 ปีที่แล้ว

      which json are you talking?

    • @videosforyou4228
      @videosforyou4228 3 ปีที่แล้ว

      @@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
      @finegap  3 ปีที่แล้ว

      @@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

  • @chrisder1814
    @chrisder1814 5 หลายเดือนก่อน

    hello Do you use custom GPT with action, Amazon API

    • @finegap
      @finegap  5 หลายเดือนก่อน

      no but I can integrate.

    • @chrisder1814
      @chrisder1814 5 หลายเดือนก่อน

      @@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
      @finegap  5 หลายเดือนก่อน

      @@chrisder1814 Amazon which API?

    • @chrisder1814
      @chrisder1814 5 หลายเดือนก่อน

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

    • @finegap
      @finegap  5 หลายเดือนก่อน

      @@chrisder1814 yes

  • @chrisder1814
    @chrisder1814 5 หลายเดือนก่อน

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

    • @finegap
      @finegap  5 หลายเดือนก่อน

      hey, yes you can contact me directly through Whatsapp

    • @chrisder1814
      @chrisder1814 5 หลายเดือนก่อน

      @@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
      @finegap  5 หลายเดือนก่อน

      @@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

  • @ShareFi-q2s
    @ShareFi-q2s ปีที่แล้ว +1

    nice video sir!!thanks

    • @finegap
      @finegap  ปีที่แล้ว

      Most welcome

  • @chrisder1814
    @chrisder1814 5 หลายเดือนก่อน

    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

    • @finegap
      @finegap  5 หลายเดือนก่อน

      you can read the doc for difference because I don't remember now, its long ago
      yes synchronization is done in real time.

  • @ptitbass
    @ptitbass 2 ปีที่แล้ว

    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
      @finegap  2 ปีที่แล้ว

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

  • @adamengbring7716
    @adamengbring7716 ปีที่แล้ว

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

    • @finegap
      @finegap  ปีที่แล้ว

      Are you developer

    • @adamengbring7716
      @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
      @finegap  ปีที่แล้ว +1

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

  • @naveedrao3886
    @naveedrao3886 3 ปีที่แล้ว +1

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

    • @finegap
      @finegap  3 ปีที่แล้ว

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

    • @naveedrao3886
      @naveedrao3886 3 ปีที่แล้ว

      @@finegap Thanks !!

    • @finegap
      @finegap  3 ปีที่แล้ว +1

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

  • @cgc2300
    @cgc2300 7 หลายเดือนก่อน

    hello Do you use GPTs with APIs?

    • @finegap
      @finegap  7 หลายเดือนก่อน

      Yes I do

    • @cgc2300
      @cgc2300 7 หลายเดือนก่อน

      ​@@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
      @cgc2300 7 หลายเดือนก่อน

      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
      @finegap  7 หลายเดือนก่อน

      @@cgc2300 google api used for its own purpose

    • @cgc2300
      @cgc2300 7 หลายเดือนก่อน

      @finegap I don't understand what you mean

  • @AdsPowerAula
    @AdsPowerAula 7 หลายเดือนก่อน

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

    • @finegap
      @finegap  7 หลายเดือนก่อน

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

  • @businessstart1810
    @businessstart1810 2 ปีที่แล้ว +1

    Thank you very much!!

    • @finegap
      @finegap  2 ปีที่แล้ว

      don't forget to subscribe us, thanks

  • @kamisama1712
    @kamisama1712 9 หลายเดือนก่อน

    Thank you bro

    • @finegap
      @finegap  9 หลายเดือนก่อน +1

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

    • @kamisama1712
      @kamisama1712 8 หลายเดือนก่อน

      @@finegap okau

  • @faisalzubair2612
    @faisalzubair2612 2 ปีที่แล้ว

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

  • @rickyvarquez5955
    @rickyvarquez5955 หลายเดือนก่อน

    Is this work on localhost ?

    • @finegap
      @finegap  หลายเดือนก่อน

      it will not work.

  • @baxtables
    @baxtables 2 ปีที่แล้ว

    How to get call this api in react js application

    • @finegap
      @finegap  2 ปีที่แล้ว +1

      you can check google calender documentation if they provide, thanks

    • @finegap
      @finegap  2 ปีที่แล้ว

      you can check google calender documentation if they provide, thanks

  • @chrisder1814
    @chrisder1814 4 หลายเดือนก่อน

    hello I wrote to you on August 12

    • @finegap
      @finegap  4 หลายเดือนก่อน

      text me on whatsapp please in the description.

  • @faisalzubair2612
    @faisalzubair2612 2 ปีที่แล้ว

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

    • @finegap
      @finegap  2 ปีที่แล้ว

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

  • @ayeshabhutto5648
    @ayeshabhutto5648 3 ปีที่แล้ว +2

    Excellent Work