https://developers.google.com/sheets/api/limits?hl=ru

## Read
- 300 Per minute per project
- 60 Per minute per user per project

## Write
- 300 Per minute per project
- 60 Per minute per user per project

#google Sheets API | limits quota ограничения

https://www.youtube.com/watch?v=6vbferZJNJY

Google docs | Sheets dashboard

https://github.com/pravosleva/react-maps-lab/commit/edc50fdd3c88a2f44d4d63b475e2cc11497aa750

#react @react-google-maps/api | hooks usage example

## Interested

- [React-Google-Apps-Script](https://github.com/pravosleva/React-Google-Apps-Script)
- [parse-google-docs-json](https://github.com/filipedeschamps/parse-google-docs-json)
- https://github.com/Automattic/google-docs-add-on
- **[Твой первый сценарий Google Apps Script. Разбор на русском.](https://www.youtube.com/watch?v=73TzJH4lNNE)**

## You can try to use Time triggers

- https://developers.google.com/apps-script/guides/triggers/installable#time_driven_triggers
- https://github.com/googleworkspace/apps-script-samples/blob/master/triggers/triggers.gs

🎓 #googleDocs samples | Google Apps Scripts

# [console.cloud.google.com](https://console.cloud.google.com)

https://developers.google.com/sheets/api

<Alert type='info' text='https://www.youtube.com/watch?v=pUktm5BIbL8' header='How to "post" html form data to google sheet. (using API)' />

<Alert header='Read & Write sheet from Express server' text='[Control Google Sheets with Node.js / JavaScript (2021)](https://www.youtube.com/watch?v=PFJNJQCU_lo)' />

**[console.cloud.google.com/iam-admin/](https://console.cloud.google.com/iam-admin/serviceaccounts/details/106684507479844867034;edit=true/keys?project=subprojects-374122)**

# CRUD operations

[CRUD Operations on Google Sheets](https://www.youtube.com/watch?v=Vx8Da4bB620)

**[Google Sheets - JSON API, Wep App - e.j1 p.1](https://www.youtube.com/watch?v=VPI27L_fQC4)** 2021

Google docs | Sheets API cloud.google.com

# First steps
Firstly you should go to **[Register reCAPTCHA v3 keys](https://www.google.com/recaptcha/admin/create)**. Also you can read **[Original docs for v3](https://developers.google.com/recaptcha/docs/v3)**. This page explains how to enable and customize reCAPTCHA v3 on your webpage...

*Дальше на русском, т.к. на инглише хорошо гуглится оффициальная документация.*

# Коротко про механизм
Помимо двух ключей `RECAPTCHAV3_SERVER_KEY` и `RECAPTCHAV3_CLIENT_KEY`, полученных в личном кабинете, Google регистрирует действия пользователя на веб-странице и создает временный ключ, который вы получаете на клиенте. Например, с помощью компонента из пакета npm `react-recaptcha-v3`:
```tsx
// @/components/RecaptchaV3
import React from 'react'
import { ReCaptcha } from 'react-recaptcha-v3'

const RECAPTCHAV3_CLIENT_KEY = process.env.RECAPTCHAV3_CLIENT_KEY

export interface IRecaptchaProps {
  action?: string
  sitekey?: string
  onToken: (token: string) => void
}

export const Recaptcha: React.FC<IRecaptchaProps> = (props) => {
  return (
    <ReCaptcha
      sitekey={RECAPTCHAV3_CLIENT_KEY}
      action={props.action}
      verifyCallback={props.onToken}
    />
  )
}
```

Компонент `ReCaptcha` сделает запрос в Гугл для создания временного токена и вызовет переданный обработчик `onToken`, который получил в агрументе этот токен - используя его Вы сможете спросить у Гугла **_\"Что c пользователем, проверка которого привязана к токену `x0123`, на сколько ему можно доверять?\"_**

## Backend: Express сервер (прослойка)
Относительно фронта: Эта прослойка получит запрос, вызванный в теле обработчика `onToken` 🍸...

На бэке: Итак, вы имеете аккаунт, пару ключей от Гугла и простой сервер на Express. И файл `.env` с переменными окружения для бэка:
```bash
RECAPTCHAV3_VERIFY_URL=https://www.google.com/recaptcha/api/siteverify
RECAPTCHAV3_SERVER_KEY=<RECAPTCHAV3_SERVER_KEY>
```

Пример middleware для Express:
```js
const axios = require("axios");
const { httpErrorHandler } = require("utils/errors/http/axios/httpErrorHandler");
const { apiErrorHandler } = require("utils/errors/api/recaptcha-v3/apiErrorHandler");
const { universalAxiosCatch } = require("utils/errors/universalCatch")

const RECAPTCHAV3_SERVER_KEY = process.env.RECAPTCHAV3_SERVER_KEY;
const RECAPTCHAV3_VERIFY_URL = process.env.RECAPTCHAV3_VERIFY_URL;

module.exports = async (req, res) => {
  if (!req.body.captcha) {
    res.status(400).send({
      success: 0,
      captcha: req.body.captcha,
      errors: {
        requestError: ["Captcha token is undefined"],
      },
    });
  }

  const byGoogle = await axios
    .post(
      `${RECAPTCHAV3_VERIFY_URL}?secret=${RECAPTCHAV3_SERVER_KEY}&response=${req.body.captcha}`
    )
    .then(httpErrorHandler)
    .then(apiErrorHandler)
    .then((data) => ({
      isOk: true,
      response: data,
    }))
    .catch(universalAxiosCatch);

  if (byGoogle.isOk) {
    if (byGoogle.response.success) {
      res.status(200).send({
        success: 1,
        original: byGoogle.response,
      });
    } else {
      res.status(400).send({
        success: 0,
        captcha: req.body.captcha,
        original: byGoogle.response,
        errors: {
          "!byGoogle.response.success": ["Неожиданная ошибка на стороне Гугла"],
        },
      });
    }
  } else {
    res.status(400).send({
      success: 0,
      captcha: req.body.captcha,
      errors: {
        "!byGoogle.isOk": [byGoogle.msg],
      },
    });
  }
};
```

## Frontend: React

`.env.prod` с переменными окружения для фронта:
```bash
RECAPTCHAV3_CLIENT_KEY=xxxxxxxxxxxxxxxxxxxxxxxxxxxxx-xxxxxxxxxx
RECAPTCHAV3_VERIFY_URL=<YOUR_HOST>/express-helper/recaptcha-v3/verify
```

🍸 Так вот, насчет `onToken`. Нужно сделать еще один (последний) запрос `verifyResult` в Гугл, чтоб узнать, насколько можно доверять пользователю, по результатам чего мы можем принять решение, стоит ли отправлять целевой запрос - в моем случае, на создание нового отзыва: в теле функции `toBeOrNotToBe` есть логика, определяющая, буду ли я доверять этому пользователю.
```tsx
// ...
import { loadReCaptcha } from 'react-recaptcha-v3'
import { post } from '@/helpers/services/restService'
import { Recaptcha } from '@/components/RecaptchaV3-2'

const RECAPTCHAV3_CLIENT_KEY = process.env.RECAPTCHAV3_CLIENT_KEY
const RECAPTCHAV3_VERIFY_URL = process.env.RECAPTCHAV3_VERIFY_URL
// Требуемая вероятность (с таким строгим критерием, целевой запрос, скорее всего, никогда не выполнится)
const recaptchaScoreLimit = 0.95

const Feedback = () => {
  const router = useRouter()
  const [wasSent, setWasSent] = useState(false)
  const [isRecaptchaShowed, setIsRecaptchaShowed] = useState(false)
  const { value: companyName, bind: bindCompanyName } = useInput('')
  const { value: contactName, bind: bindContactName, reset: resetContactName } = useInput('')
  const { value: comment, bind: bindComment, reset: resetComment } = useInput('')
  const showRecaptcha = (e: any) => {
    e.preventDefault()
    setIsRecaptchaShowed(true)
  }
  const toBeOrNotToBe = useCallback(async (token: string): Promise<string> => {
    const verifyResult = await post(
      RECAPTCHAV3_VERIFY_URL,
      new URLSearchParams({
        captcha: token,
      })
    )

    if (verifyResult.isOk) {
      if (verifyResult?.response.original?.score > recaptchaScoreLimit) {
        const createNewEntryResult = await post(
          '/entries',
          new URLSearchParams({
            companyName,
            contactName,
            comment,
          })
        )

        if (createNewEntryResult.isOk) {
          return Promise.resolve('New Entry created')
        }
      } else {
        return Promise.reject(
          `Bot detected! Your score by Google ${
            verifyResult?.response.original?.score
          }. Humans limit was set to ${recaptchaScoreLimit}`
        )
      }
    }

    return Promise.reject(verifyResult?.msg)
  }, [companyName, contactName, comment])
  const dispatch = useDispatch()
  const onToken = useCallback(
    (token) => {
      toBeOrNotToBe(token)
        .then((text) => {
          dispatch(showAsyncToast({
            text, delay: 7000, type: 'success'
          }))
          // resetCompanyName()
          resetContactName()
          resetComment()

          setIsRecaptchaShowed(false)
          setWasSent(true)

          router.push('/feedback/thanks')
        })
        .catch((text) => {
          dispatch(showAsyncToast({ text, delay: 10000, type: 'error' }))
          router.push(`/feedback/sorry?msg=${encodeURIComponent(text)}`)
        })
    },
    [toBeOrNotToBe]
  )
  useEffect(() => {
    if (process.browser) {
      loadReCaptcha(RECAPTCHAV3_CLIENT_KEY)
    }
    return () => {
      if (process.browser) {
        // Derty hack =)
        document.querySelector('.grecaptcha-badge').parentElement.remove()
      }
    }
  }, [])

  return (
    <Layout>
      <Container className="box">
        {!wasSent && (
          <form onSubmit={showRecaptcha}>
            <h2 className="gradient-animate-effect">Feedback</h2>
            <div className="inputBox">
              <input name="companyName" placeholder="invisible" {...bindCompanyName} required />
              <label>Company name</label>
            </div>
            <div className="inputBox">
              <input name="contactName" placeholder="invisible" {...bindContactName} required />
              <label>Your name</label>
            </div>
            <div className="inputBox">
              <textarea name="comment" placeholder=\"invisible\" {...bindComment} required />
              <label>Comment</label>
            </div>
            <div className="special-link-wrapper fade-in-effect unselectable">
              <button className="rippled-btn" type="submit">
                Submit
              </button>
              {isRecaptchaShowed && <Recaptcha onToken={onToken} action="feedback" />}
            </div>
          </form>
        )}
      </Container>
    </Layout>
  )
}
```

# Samples

- **Back**: [Source code](https://github.com/pravosleva/express-helper/blob/master/src/server/routers/recaptcha-v3/mws/verify/index.js) | [Swagger](http://pravosleva.ru/express-helper/swagger/#/default/post_recaptcha_v3_verify)
- **Front**: Source code | Demo (in progress...)

#google reCAPTCHA v3

#smartpriceSSR метрики на сайт google tag manager

https://github.com/akkii922/google-meet-clone

#google meet clone

See also: https://stackoverflow.com/questions/35348234/recaptcha-gets-invalid-json-from-call-to-https-www-google-com-recaptcha-api2-u/36862268#36862268

```js
const fetch = require('isomorphic-unfetch')

const r = await fetch("https://www.google.com/recaptcha/api2/reload?k=6LfgS2YbAAAAAN1TP8TA6V9S6GkMGdjZiUojf1S6", {
  "credentials": "include",
  "headers": {
      "User-Agent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:94.0) Gecko/20100101 Firefox/94.0",
      "Accept": "*/*",
      "Accept-Language": "ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3",
      "Content-Type": "application/x-protobuffer",
      "Sec-Fetch-Dest": "empty",
      "Sec-Fetch-Mode": "cors",
      "Sec-Fetch-Site": "same-origin",
      "Pragma": "no-cache",
      "Cache-Control": "no-cache"
  },
  "referrer": "https://www.google.com/recaptcha/api2/anchor?ar=2&k=6LfgS2YbAAAAAN1TP8TA6V9S6GkMGdjZiUojf1S6&co=aHR0cHM6Ly96YXZvZHNlem9uLnJ1OjQ0Mw..&hl=ru&v=yZguKF1TiDm6F3yJWVhmOKQ9&size=invisible&cb=7k1lfgyfvmq2",
  "body": "\n\u0018yZguKF1TiDm6F3yJWVhmOKQ9\u0012ä\u000b03AGdBq25JPtBVX0c0le7ncRoLFrwHnQNOS-e5lHJr2NtC1aCHHFR4imtK1tVyl3dLpDM9SGDujPTE8mqjw6uzP3JAKvSE2eVQT-F4qYAqwwx6I6Y0f0ru4vdruhue_k1lftxuXmBuk2OlSswAPg_lObQ04mzIPlJP1Z7uwcbIKQxCz9tIY0e4FlqGydqGhtJWXTHdLV9whWjtQ0CFP1RkCU0oQpo3kx2oKYL0j12Zvl7lV8RoFWbJhh9G1GCQFq6lHQ8f-hDQE31h4xDvHc2sCD8vFWLSSjp1GKdX_G8bH_xNiv5nscIlFmIqRA4JoHO8D5oSEw7SqoIU2p-fsglg0sCv4sFpImX8FjAHuJ3-6oCXYBoyDwzKOAsyppqYGOTIwAwkmCR7i9hIUvlLdFQIavmok7ItmogF8qBUjmg-4hfiCydSoJRTKE6KMJHMBlh_h6jl_fVNDRZLhfkL0m-mf8gfBIdBdri6_SDz9T5Ns9CmhcsPv2_5Dq1SESO3NBmmosmNsIqoOQaiecZhO_qQlqnVLVKYGs1M0-Cq7vYSYKUgfmHu8twVb64qnXmII8rbKtoTjFs6X5sEuVfxg3jOhOuLTDIcHrJoFgeXlQSnDvo33pm7JzzjNOz1mrGDHOHLnvEsyD9h0Us_6vXGJz3S1ljYIkAGzRZpD2jplCmZLKx_k92-IvCrymsiybEBWdZ_R31clRog3sMB_QUbf3nhXWaUaqbhkdyHnLr3VLYBOn4oLI2l4jGJ4gzJyNYH4zFHPC5FOKzEv1omKjmDKaR8Apeu7zKSzPvA8iv4CZl_qip1luUjEmnaGqyTiANUdDBpLucFb-tUE3wjp4SfBHYzcX7r2W4sujFE649NwVHagG7VnuEk_C6zPowYRKOj0juLC8kFngPXejjXHp7J3StGjIm5FZyRodVi9bSKckvVyKkF_ofYUnhJPhmQtvfCGEcmaei2jGIg90TZXZbQr7yseRkMTde2VZAP6e-_z74fLb_vJF98pQT0hMfPTWQH0G9N0KMNWGPcgdRNfg8gS-DZHEPTUNkJpb4hBH57FTnZQH4nJlad2iI_P6nVHfGHuuQCiNZ7GXCFnQw4qrFP7BkXPP0okOYLeVcft_o77vrSN9M6T-PdeMVIn_Y6mQn4sva3iX0cKn68VlGwHgU30bsBgkpB4sy54MAZtK6dvTz9DANlsEZQY00Cp5bPDNLgmpBJeFsUhf2viw1rHCTQEcGk_YVxKHPKsO1dOcE2hf8m0OrTq-ZYgV51hVRyLdML3T0XtigNpe7mRMsDC9FPaTTkAUSkb-8QnRh7-yAA9k4jF40ELwyVBpwCtg1gNyl0pYbUNJHCiSqNiKuQVMEHBvD9rE-tU6kC0O0jWy9lpvN0HsW-HaD1H7zupnnWL-LTyhPaw6Q2Enw-fMaq5TTI_pVa8a08wILpS3awKGsMMruPRQ5QD4KMvMQkQ8_A6ZgebCAKCdnEcxaoNrjlzc_i62Sf1b4h-F-9pbOB-Q\u001a\n[30,35,95]\"´ !OT-gP3LIAAZRs3gYUbNH0ENGK96V1UU-ACkAIwj8RjnRxYJIKuCwkomfGvmXIHStPuynMi7PGX_HMCris_PY76D0iwcAAAA3VwAAAARtAQecC9MfC5P0bD1L1vvXwn52zoVgSFK6tN0-bQ_3WEXpm_rmaAbCf5PA17cAJuT3_joqGI1pqbtcSaq6EmipfZEwCArPt5P0NuzGbVIRFYX6e0BUJgwa-msCvd8I1AbsZPfyWEKtA2UUJh8whUsVCisHpbBAxeAnDXMUbCb1S6URkgFm04iv7F5dysPMjvDKudeW03EfvZVl9evH6-Eej5uyCx2jN5B3n49mxtHJzWCE-keKsbceR6I47vqcUjjeUJpAi9PBMLzz-JeCNlZW-4z6hyGhW9ybjVedB60jUq2sDsV8VXxXPXPrhbd-KvJMqHXt7-gNEGjS504OnBd3QPU5NtlH7Ed8y4Xyr14H1wuQt1Tjy7vU_NYK491xvbL4-Ko2mNij4xF72Q-6_ZdzcS9zYnILVgnSh7hErb5rGPOFnNvYzqf5eN3DKnDt-Ul4RuuxuuIzRbpyWQunKK9n7d405zR0nZZTKaEiDsVRYV2fxkd3Cgny9i0u0c-tFVln_4yZUK7vovrjUe_3ic-BqfIMIPybf3HOqHAdBtGp3p5oscUTBm04EZLsaimW0urLWu6Nw4qUOFCEpM5VDnTgqwE0SflzUqHxEpupGlKmX8KETlvzXXP7Tq7RYzLPDe8AXUao9uK2C_NnNrm6GIK-wdfqYwkw9uW2GGD5WJYr8mcfFhHvxfyHK2VM5C6as59xIOTz2qkbUFmWx8di_ilN4gmuJdbQsdH1c0anLVlfQjfg1nY-sun00KhJXIs2qrpvgJGEwJyYKF3afaB_oqR37vxtZXL1aEFMblkKghqOEWiQAOru7efGV3tFJniD1JouL7GnMeuI9lLJzEd_uewTWNqJWYppsWHe3CSEMaqX3wTJfuA6-JB__wqZsSBMYsWNR5ulWXtJxBE0A9aUcwr4vS-RUCht33MObMmwomEDKglBVdtZWXyN-BAHzUSfYYQvT0v89gGjv7o29ohUGDewJxjU1yMmPpIojLQPxNdjRRQ3s4FSghBUfYnQ499t08etl-eH5aINjSdrSwtWBQNPNHj6xEfYZqyzlyHAvahfWmbMTBd_esckE8_2EbtKOjHdOGkOFqTMxPEIhQBF5-Mo24lHZNUl943uWKcO0aZDWhVwsm0txdj29L7_QdtaWgju4ZGDKOe_b1jYDTl-ngzISpINmuK2wbL4tekrIf3or3HXJkIlboi2omCIQA1OEDaS7DjzVReg2nrfouEGVSYKDyeIw1Z6ap0kubN-rgR61AJ1k4aQziAah61kb_Mtd_YD0zQ_jjehl0QuvEixifGiPEXWxg_9nSjSG-c8bq5dWqQGAmMxVgv235-gXg4KTC5J3h4Se8dPvcmk96auK2itc9tqW3jTNH35denq7ZtHGYqMdocFijRdAKG41Vu_MDrAk502z3IopxqLJuQhTJerGnZBWGOtCQjNIv6ZHA0g0QkgLpbUQxp5QHbXz-_1ppVMyHrsYmlg7Zu1M9y6B2ipj_yfB1Q6A-B9NOuJ3xqA6-dJRirK5DnSbft8gVIid1xeCyBrZ7QwZIh6ewTTuBzdqsf17S8tegAT2NjpTUE_VuuMvUK4tJ_QfTTtJRF6-pnwhmvPEnGsc5FpkUkm9EStPa0mVDuLASiusRjQZJSeu3x-iVDbrmtj742RHpQ97PLAVeeSqp5u3Ky_6sUSARoulaKmlMO_mS7_PQHwQfJrCCqyO8yEyeTekI0zVFr4gm-h4497xFyIgsg-S-95quF8iFKkqkz5lWZM8CR00xB1c5yaUtJiGO7_A66QAhDi-79__jCoJ2cFbpuLewAal1Wuc1ou1NZTyRsujYNTz3YEDkihkXi9WFCO2KPjHWpD442DdlB52pIbpk4UTIosJ5ybnH8TxT4739GepR-qDJ2QodA703N60FKhenZsqAaY-mxvAL5Gk65f9I9xnbuDg35xopyO4Eb0LKDWpVA9Zy6zgXOfzBmObyqzDTdIra6A6aBGglfW6-zzMtfxBJcmg5I06aZAb_WnUcLL7ALaApwNCJi2klel0CUtgdFMcEeHlOfnEUCrC170hZKNMcovlEClHEeOBibRoN5MxS9C4RcFl2d-ksyXwr3E-EFcGz02OiCM7Q5B6rckjOvg132YiNWVmOiBKaobPArA7Sf2_vg8MnWr53cuKZYl7kfWCBQzuUASf09eLI2zKJLOKHWC-OS_Hr-aeDbzYPREdQknTHivFJDKAiX-JBqXyhYnX9sTvdjhNDGpASNADis2WIJjVExyr6VJh_oud3eRXLZfzC_gIlvtldBOwvFiyQEKiv0oMjb1tOM_OKx7TSvGbu6F3XViHxaNIbntV1mZkNvDxaFGIlPLtNzWdT-nE5jzdGOwNpVcOfs4ZN3tGkH-3KOjSNbIr9UzPyRomMXI3096is6SmEdktl0_0yx_rnA2ommgYYg_7QitwnDohdQ_5WwZ8DeA4gaSDObhdaSDKrywgtiFEwkinCMktNceWBYmJIupsly-JijfK74N1YDo1rriGPR92KoANJ__P4Ptg9L3tzZFvBAId9bInxxBMkh5qA4VDAxjo8oljFMsjebXOxMOhg6j5Qv3Zvb1628JbGbT97O4dZpSbeldwjYPsJ0Q6YcVY39PafOSf3eTq_ZNX8EKwbvIH99duCsGtg0NS3IzM3Ytvpy3C56MVP9mDhYSEF4-M9Acl7-3K4urxp_R9EobQewSqRuNvxr1NuyEKzWbv7W5yA7laT_AuIqaPsgzQ_rEr2jcQ_cJm3UG3d2koPP3L69MkewKUdU23KrAKyP4w18sebVm_bE9_NNxZtoOOUPL2XwC_ggVlTIBEaoTS5oK_wkT6Plw7p9MNsAa7ez-6wlwsCa-29cv_FiK6KvOBzrM15uZzSvCHscqQmwQbn35vJzbLT26c9Ilxe1V3ZAjkuo7uS9F2WULY_OzJH1U1UJMpHU5Md62Btn-53yTuoQsuLQLb5aqMdOYpws5O0QAN4pB644v-8oWhskCC-C7L-7zTrx8kmUjwN2EXIjQjHbQkOcvY3WGd2wmc4fuBZLJTaE4EMwE1DAjzh2lR4ONevSA1R0hkA5F9TRpUh0g_fjq9Ov2biCC0NdwyER2VjxJNZCCQaNt9lwknHTeoKVqGY2K_hyVZA-dFbG7OK6uz4wMfQXnHbe86v5GfkN9SWzQr0-rkNqAqjHSUd8YkCppyKff66vCdC7MO5amKrdZb7APBHRbXRWvqyVcgmzkHDYjVuBYJcQ2l7YKd0A4G1LV9h1KXNLGZtGjs0hra2bUH7V0wL2lYTeDKdkr330aB_VIYygQNuTHFpxkdisWyoIMZaPDXat4fwcife71I4sf0xQA26oufzyk7ZSL2ZBvXFxM89hCxCVJHbZwCXmOtAoNZyQs6sdnlp9mNCKghArx91Tlar67_LO_ACsR-6-RlyHbw8RGNmq9JEFCBWFll5h4Us6yjbDMjqMxR6st6gZZ3KMMx9QZb7TozKSNY0e-aD08keq7tXjERxyPa0b-WFuRnJO0T6cW3IyxGf_fJKKmzcybhB8-pzKjpcsvo-qeMEnDTUI6zyPkiTEAWvK_P8hr7mFDYYzB5BuNioSkWx_XWk0fZSxrhTGXjW84D7lKtRKi51xNxc7BMBVhNZ7dup_AGE4kFb_4tFu5HxtyRRZ-_fEEsjlbciRnU67Dc5HJUGFzVWS6h21eImzmBRxO_EP9rpGmIpvkprSfZ9wxiGbUlUTN-3b8uO5ZovVGAjc1H0PTMqxdD65YsocTMqlMlYrrioNR94PSqcHCf7hgq5FojCQucMR3qT1M4EKunEmdyYt6WgzxdlR0DYWnmA2Rcb_qOipktlg1sG8RSjg5vpaPuFOclkGSuINigB3jEP3ep9YPb2x20LTfssLRfPSCq2G0vwtzTaaoMV54F-7cKQ3vaTSwvHEEbEBk_fNKEI9DDZeBqJe4AadLqfcRzz2YipCYEVfz3njUdDnhSphI8fwoNDclcfYcYmw8sQjp-EQg8mtjglaL7E-8eDb2IJrvbk9Tgp7tbtlYIeh4ZfNV5Jo*\u000b-10446832852\u0001q: \u001105AHwm4hJHBKDPssSBubpffcJsiav5NfSmHNRrHq000LURI4J9qw122wfaRE9kGaVU9kZiwyEvsxtkXJvgoIVHPbyC1ks2NEVUaHPDtAxfgXq7ATB2qtByBtwkwbfhu9P_tgKJbi7N8Os51f8XFzpL7ffhQvlUlcfYOQmRru7BDCyx2dgRsuw47iHlQb-gkXXiQwC_9MvNPF0aRSBtiYf1Q057CM1lSj2WA_Z_LHoBCG31i4uIE0VlUk1tCGRlxSvBLaOx-_TTAwAUIcKsM_PdvEvtreeOVyeHrpLavESH0y_qqV1wrAx63wnQ47_1Z0VKoRUpbGVLJ7OZ8frDdAiTnE3m4LJHuMv1Jq38bn1vADtqIu3z02gYzEu657RQL-kDhw6Z4VslmbNtDhNlwAFTWUuF85G7UjIcc4GwZ3vU2SX14tdlclKlJQnulnXkXVFmGSi9qolGQO79PIo8M8SdHXFD3dRLSaKHBhV8vKn9RFa4P8JMm_X3pvhkWQPpoJO_kwTfime6TYAc47jaO35cEHStLXr2vAJ-GlP6Z2lkoRqYArUAdjy7UswtdC4pFK2GDFE1XsD2ZhrB8U84pvYJ08h17dsinqMVG7aYb-pGfONykC8MDs9Ela2-q-HNxKc3Cw3RLbteslgTfQA4n9WkVZy3K2RexCfXr1gxdhw4YDE-Dn9G3THSjlC99bKrYE1DUYjj9qGddRbvbG9yHHI81s70ceVISqCBzS33BGzSQ8xvMCKr37LyOYgndGqB47HK56-nRi3hOFxiZVZHg2gJ_NcVP-6mv_ct83AID4wtCTirXbudWdMqXPVIzvUIKg5c1Yv84i3ECUGKFPuyRc--iT-hQKaOVt3xGs7JgftA-QHjymOARMveKHCzN10UrALHrlgmKP5pgtWKMDnJrOb4by63aYtNpBnt-Gwgkv8ypNG7ZihskCHIff0JdIO44NnVzdayGz6GTPVr3dmwPFd19UG3AR8sdaawiYGa3zSF3A-IJJlEevqxRiFtqjGGHsQpMb81MnEbVgyyCArOKjeMPtRO2fwvXjZKkT32zeSanYrWfgNmOrBIPmD6VW6cE9K122uQcnc3LXiM8ojX2-4oYsrBI-bdceJNQ0gjvTTAYPY9zOL940nTY45c3rE75pQ-LteyOucRx6lUkQk5Vq98wY4EcoWnSovyW9NHjU5ZndIWBJ1AwS604HfSxjuh-AgUtKXX1wY4h5dqMEuWBaMRn9KCIgyh6prqfyDq7H25f-DQsTYbWhJ56qGXndNdy5nO0cRkOeregdYvS3yqiZUzVb5deaSRT2y32Att5_Ek1tI8xDLpksFkvD83ehTYdFclstTTZ3L4VOrJ-DrrE7c0PxCYtlCFF5YCcl9z0RIZAVPzrsrTjBC9zwkdPFImPGa8d3WXFUOfDqwWYTzSwftcjx445OQ_PYgwCq94bxGaUdwFYAKaOHME86EKC4kKkk_cS-Wd48j73XZgBFi_SWX8Wj1w0-YWHA0-NkPsYR0C_Ot-PjZszOqMymxD_xNeeRakiGv4H6MRz9uI20ehH6HUBuA37Oibz89KLNwn-A9tmuk89hkkg1dQ64uEGRwSUEmz9UiXaPxiouqsnBBcbbS-ZMmp3-SKXydo4teaaclVrNvK3e7DHC_nhYb-f7HPkWrXY3hAvg7vHyKeBW48V-OtJ1EHM985dNfPNys3wAtqe6VfxLUmCTrPu9lP1mceF7Rxk-YiWH736YULdkVpIV5DltiomKnHHCNoop1RNcKp1TMQZy52YpFAXgfo8jaE5fpYiztgtTR8GH1TCwGtRN_Sr6x0lWQlwr6J-FN3QW5w2XzRigh9ESxZAtMp--dn9AQtTJwSE78WSq9rVWIkC_vZfbjmsBQRhRtlSFU9PwpLNDpHwn9bRqQwZ3pVBxPkLQRfJab4dZHIMp8SzVufLor1XqYDJhKuZK6uvWsxvHs_46dLs_aq7-V5RUxbrRCUhm54Dtcd2_2oADAS7PhnpCD-I8l7DM6u70VQ4ksdDUHpCUfrCjYX-gGsAIqOHNyQvNd4sIY8iXPUMF5I-NZaQeiuVuID39hv7-lSwXl8PL2ORRhVVK7zIu-3oYqNnP2aMq7KBno5iHr2km7Zwa1e2Bm9DPzWUx-cOq6pViZvzorM64cxKTYF3nEvehC9ATI9JSiIJqx6ARTBu1atx5eGqyOeA5QXRlDHSwB\u000bcontactformr(6LfgS2YbAAAAAN1TP8TA6V9S6GkMGdjZiUojf1S6",
  "method": "POST",
  "mode": "cors"
});

try {
  const text = await r.text()
  const normalized = text.replace(")]}'\n", '')
  const json = JSON.parse(normalized)

  // console.log(json)
  fd.set('_wpcf7_recaptcha_response', json[1])
} catch (err) {
  console.log('-- ERR --')
  console.log(err)
  console.log('--')
}
```

#recaptcha #google | recaptcha gets invalid json from call to https://www.google.com/recaptcha/api2/userverify

https://metrika.yandex.ru/stat/visitors?period=week&filter=(ym%3As%3AisRobot%3D%3D%2527No%2527)&id=64844911

https://analytics.google.com/analytics/web/#/report-home/a169297642w235891081p220889502

> **See also** [About evets](https://developers.google.com/analytics/devguides/collection/analyticsjs/events)

#pravosleva yandex metrika; google analitycs

🎓 **2021 [🧰 Отправка сообщений из Google Таблицы в телеграмм по шагам V2. Как бы я написал скрипт в 2021 году](https://www.youtube.com/watch?v=MR10T4WPBmc)**

```js
const TG_BOT_TOKEN = "<YOUR_TG_BOT_TOKEN>"

const setWebhook = () => {
  const webAppUrl = 'https://script.google.com/macros/s/AKfycbw-rwNxUvBC7S9gES_jJCnZNEpar6oWc7kaJxMIWDuZdikiLCTmTUJGY9clGKcr0qKUDQ/exec'
  const response = UrlFetchApp.fetch(`https://api.telegram.org/bot${TG_BOT_TOKEN}/setWebhook?url=${webAppUrl}`)
  const text = response.getContentText()
  // console.log(text)
}

const isIdDetected = (id) => (s) => s.getSheetId() === id
const getSheetById = (id) => SpreadsheetApp
  .getActive()
  .getSheets()
  .find(isIdDetected(id))

const doPost = (ev) => {
  const mySheet = getSheetById(0)
  const { contents } = ev.postData
  
  mySheet.getRange(1, 1).setValue(JSON.stringify(JSON.parse(contents), null, 2))
}
```

👉 [Телеграм бот и гугл таблица: создание, webhook, логгирование](https://www.youtube.com/watch?v=WBCzNFWj1Ao)

🚫 ~~2019 [Отправка сообщений из Google Таблицы в телеграмм по шагам.](https://www.youtube.com/watch?v=8hkgWtgLxdc)~~

> See also: [Получение в google таблицу данных из telegram бота (под ключ)](https://www.youtube.com/watch?v=RatU5frnvnQ)

🎓 #гуглТаблицы #telegramBot #googleDocs

https://www.npmjs.com/package/react-google-login

#google login

https://demos.creative-tim.com/nextjs-material-kit-pro/documentation/google-maps

#MaterialUI | google map

#nextjs #googleAnalytics

- https://tintef.github.io/react-google-places-autocomplete/docs/
- **[react-hook-for-google-maps-places-autocomplete](https://reactjsexample.com/react-hook-for-google-maps-places-autocomplete/)**

google