Laporan keuangan, pencatatan pengeluaran dengan Bot Telegram yang terintegrasi dengan Google Spreadsheet

Overview

laporan-keuangan-bot

Laporan keuangan, pencatatan pengeluaran dengan Bot Telegram yang terintegrasi dengan Google Spreadsheet

Mulai

Buat Bot telegram

  1. Buka telegram search @BotFather
  2. Create New Bot /newbot
  3. Masukkan nama kemudian username.
  4. Setelah berhasil maka akan mendapatkan Bot Token.

Buat Spreadsheet dengan kolom:

  1. ID
  2. Tanggal
  3. Kategori
  4. Item
  5. Harga
  6. ID Pelapor
  7. Nama Pelapor

Buat Apps Script

  1. Buka index.gs
  2. Sesuaikan Token, Spreadsheet URL, Nama sheet, dan Pengguna bot (Chat ID*)
  3. Deploy sebagai Web app, dan simpan urlnya

Set webhook Bot Telegram

  1. Buka di browser https://api.telegram.org/bot[token]/setwebhook?url=[url hasil deploy]

*Note:

Untuk mendapatkan Chat ID, buka telegram, search @getYourID_bot atau https://t.me/getyourid_bot

Contact

Telegram: https://t.me/mastgh
WhatsApp: +62 851-5541-1484

Donasi

Paypal [email protected]
BRI 000401061441500
Jago 100310049829
DANA/GOPAY 085290465350
a/n Teguh S

You might also like...

Telegram bot for Youtube-dl

Telegram bot for Youtube-dl

English youtube-dl download telegram bot ydls와 함께 사용할 수 있는 봇으로, Docker가 설치되는 곳이면 어디든 설치가 가능하다 (ex: 리눅스 서버, 시놀로지 나스) 기존에 ydls 이미지를 그대로 사용하였지만, 채널 이름과,

Oct 19, 2022

A telegram bot that sends the current day's foreign exchange rates to its subscribers

Birr Forex Bot A bot that sends the current day's foreign exchange rates to its subscribers. Using the bot Check out the bot here. Running the bot It

Dec 21, 2022

A typescript telegram bot with just two works in mind.

Minitsbot aka @Akagiprobot Made in ❤️ with Grammy and deno. A typescript telegram bot with just two works in mind: Autoapproves new join requests. (Ch

Jun 7, 2022

TypeScript bot for auto-deleting of Telegram premium stickers with some interesting features based on the grammY library

anti-premium-stickers-bot TypeScript bot for auto-deleting of Telegram premium stickers with some interesting features based on the grammY library Thi

Dec 15, 2022

A Discord - Telegram bridge rewrote from scratch, in Node.js

Discord-Telegram-bridge A small and fast telegram to discord chat bridge, written in Node.js Setup: If you want to run it on heroku, you can just clic

Apr 14, 2022

exercícios feitos com o pessoal do telegram

Turma - Pré-Trybe Desafios para treinos Exercícios feitos para pessoas que estão aprendendo agora!! Entre em nosso grupo no Telegram e no Discord Níve

Jun 13, 2022

🔔 Get an alert on Telegram when there are Raspberry in stock ready to buy

🔔 Get an alert on Telegram when there are Raspberry in stock ready to buy

Raspberry instock check bot Get an alert on Telegram when there are Raspberry in stock ready to buy. This bot uses the website https://rpilocator.com/

Dec 16, 2022

Telegram-API Library Written in TypeScript

TeleLib a node js Telegram Wrapper written in TypeScript. installation yarn add @telelib/telelib or npm i --save @telelib/telelib how to use create a

Jul 27, 2022

Discord-Bot - You can use the discord bot codes that are updated in every video of the codes I use in the discord bot making series that I have published on my youtube channel.

Discord-Bot You can use the discord bot codes that are updated in every video of the codes I use in the discord bot making series that I have publishe

Jan 3, 2023
Comments
  • Bot No Respon

    Bot No Respon

    Webhook sudah berhasil diset image namun saat trial coba data /new, Bot no Respons image sudah coba buat 2 bot dan 2 spreadsheet yang berbeda, namun tetap no respon.. mohon bantuan nya mas Teguh

    nb. saya ada chat via telegram juga ke mas Teguh.. Terima kasih mas

    opened by eduardusguntur 2
Owner
Teguh Santoso
I'm a Web App Developer, freelancer.
Teguh Santoso
Ramdani Botz V16 adalah bot yang di ciptakan oleh Ramdani Official

Ramdani Botz V16 adalah bot yang di ciptakan oleh Ramdani Official. Jika kamu menemukan semacam bug/error, harap untuk dimaklumi sementara.

Ramdani Official 4 Apr 27, 2022
Bot sviluppato in Node.js che permette la prenotazione e il successivo invio dello screenshot di quest'ultima tramite un bot di telegram.

Unimore-Bot Bot sviluppato in Node.js che permette la prenotazione e il successivo invio dello screenshot di quest'ultima tramite un bot di telegram I

Lorenzo Codeluppi 8 Jun 9, 2022
Weblookup Telegram bot - The usefully bot like check website, screenshot

Weblookup Telegram bot - The usefully bot like check website, screenshot

Fusedev 3 May 9, 2022
A multipurpose bot, a clan bot, a all in one bot. The one bot u need for ur server originally made as Milrato discord Bot and by Tomato6966.

Public Bot and Support Server! Invite the Public Version of this Bot so you don't need to host it by yourself or join my Discord server to get a custo

Tomato6966 472 Dec 25, 2022
Cem Karaca - Telegram Bot

Cem Karaca Telegram botu | Bot Cem Karaca şarkılarını tanıtmak için yapıldı. Bot: https://t.me/cem_karaca_bot Botun kullanımı: /start - Botu başlat /h

Lucifer25x 1 Jan 10, 2022
Um simples bot para o Telegram que baixa vídeos e áudios do TikTok & outras funcionalidades

Kelle Estella (Telegram) Um simples bot para o Telegram que baixa vídeos e áudios do TikTok & outras funcionalidades. Clique aqui para utilizá-lo. Com

Luis Gabriel Araújo 3 Apr 20, 2022
Telegram & Discord chat bot for Airline Manager 4

AM4 Bot AM4 Bot was a Discord & Telegram chat bot used in 63 servers and across several Telegram chats between 2020-2022 for the game Airline Manager

Fin 5 Jun 5, 2022
Telegram bot with a graphical interface that enables you to schedule messages and generate automatic replies 🤖

Telegram bot with a graphical interface that enables you to schedule messages and generate automatic replies ??

rn0x 5 Dec 6, 2022
Telegram voice recognition bot

Node.js bot for telegram messenger based on Microsoft Azure Speech Service and Node.js Telegram Bot API

Dmitry 4 Mar 9, 2022
a Node.js boilerplate to start creating your telegram bot without too much configuration at the beginning

node-telegram-bot-starter-pack How to use clone the repo run npm install run cp .env.example .env and replace the variables with your data define your

Mohammad MohammadAlian 7 Sep 7, 2022