Image from Telegram Bot to Google spreadsheet

How To
,
1

Hi!

When i connected my TG Bot to add row in Spreadsheet and send to TG bot text message thay working okay. But when i try to send image Spreadsheet add a row with text “[collection]”

  • i’m using the template scenario “Save telegram messages to a Google Spreadsheet”
  • i’m using in Google spreadsheet Value A is “1. message: text” and Value B is “1. message: Document/Image”

Help please, how i can send image from TG to Spreadsheets?

2

Upload it to drive then download it from drive then send the web view link to the spreadsheet

2 Likes
3

So you suggest to enter a module “Google Drive Download” after “Upload”? How will MAKE recognize the correct file(s) to download (in the Upload folder might be files from previous uploads)?

5

When i try to creating a connection to Google Drive i see the error like

Error

It is not possible to use restricted scopes with customer @gmail.com accounts. For more information on how to connect restricted scopes visit our documentation

6

You will need to create a project on google cloud console first
get authentication first from their you can create a connection

7

when you upload a file you get a file ID after uploading that file ID can be mapped to the download module

8

1. Search for and enable the relevant API (Google Drive, etc.)

Direct Link: Google Cloud console

2. Insert all the known Google Redirect URIs for your app

Direct Link: https://console.cloud.google.com/apis/credentials

How to create an OAuth app in GCP: https://www.make.com/en/help/tutorials/calling-google-apis-via-the--http-make-a-oauth-2-0-request--module ← FOLLOW THIS

505×537 31 KB

Here are all the known redirect URIs you need for your Google Cloud Console OAuth app. If you set these up, you can reuse the same GCP app for other Google apps and modules on Make.

https://www.make.com/oauth/cb/oauth2
https://www.make.com/oauth/cb/google-custom
https://www.make.com/oauth/cb/google-restricted
https://www.make.com/oauth/cb/google-cloud-speech
https://www.integromat.com/oauth/cb/oauth2
https://www.integromat.com/oauth/cb/google-custom
https://www.integromat.com/oauth/cb/google-restricted
https://www.integromat.com/oauth/cb/google-cloud-speech

Once you’ve set these up, you can use/reuse the same Make connection for all the supported Google apps & modules on Make - you’ll only have to enable the respective APIs for your custom app in Google Cloud.

3. Publish your GCP OAuth2 app

Direct Link: https://console.cloud.google.com/apis/credentials/consent

You might need to set your OAuth application to “Production”, otherwise the credentials expire very frequently.

1. To do this, go to menu item “OAuth consent screen”

or click here https://console.cloud.google.com/apis/credentials/consent

575×505 33.6 KB

2. Then click the button below if the Publishing status is not “In production”

1002×683 45.6 KB

For more information, see https://www.make.com/en/help/apps/it-and-development/g-suite-admin#connecting-to-google-services-using-oauth2

2 Likes