title: ÐÐ²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ Ð¸ Ð¼Ð¾Ð½Ð¸ÑÐ¾ÑÐ¸Ð½Ð³ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð¼Ð°Ð»Ð¾Ð³Ð¾ Ð±Ð¸Ð·Ð½ÐµÑÐ°, Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Google Sheets Ð¸ Postgres
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Small business data automation and monitoring using Google Sheets and Postgres
Creators: name: ÐÐ°Ð³Ð°Ð½Ð¾Ð², ÐÐ»Ð°Ð´Ð¸Ð¼Ð¸Ñ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: google ÑÐ°Ð±Ð»Ð¸ÑÑ
appsheet
python
postgres
xml-ÑÐ¸Ð´
google sheets
xml-feed

description: Ð¢ÐµÐ¼Ð° Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: Â«ÐÐ²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ Ð¸ Ð¼Ð¾Ð½Ð¸ÑÐ¾ÑÐ¸Ð½Ð³ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð¼Ð°Ð»Ð¾Ð³Ð¾ Ð±Ð¸Ð·Ð½ÐµÑÐ°, Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Google Sheets Ð¸ PostgresÂ».Ð¦ÐµÐ»Ñ ÑÐ°Ð±Ð¾ÑÑ:1. Ð¡Ð±Ð¾Ñ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¸ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ° Ð´Ð°Ð½Ð½ÑÑ Ð² ÑÐ°Ð±Ð»Ð¸ÑÐµ Google Sheet, Ñ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÑÑ Ð³ÐµÐ½ÐµÑÐ°ÑÐ¸Ð¸ XML - ÑÐ¸Ð´Ð° (ÑÐ¾Ð²Ð°ÑÐ½Ð¾Ð³Ð¾ ÑÐ¸Ð´Ð°) Ð´Ð»Ñ ÑÐµÐºÐ»Ð°Ð¼Ñ.2. Ð¡Ð¾ÑÑÐ°Ð½ÐµÐ½Ð¸Ðµ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸ Ð¸Ð· ÑÐ°Ð±Ð»Ð¸ÑÑ Google Sheet, Ð² Ð±Ð°Ð·Ñ Ð´Ð°Ð½ÑÑ Postgres.Ð ÑÐ¾Ð´Ðµ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ»Ð¸ Ð¸Ð·ÑÑÐµÐ½Ñ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½ÑÐµ Ð¼ÐµÑÐ¾Ð´Ñ ÑÐµÑÐµÐ½Ð¸Ñ Ð¿Ð¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð½ÑÑ ÑÐµÐ»ÐµÐ¹. ÐÐ¾Ð·Ð½Ð¸ÐºÐ»Ð¸ ÑÐ»Ð¾Ð¶Ð½Ð¾ÑÑÐ¸ Ñ Ð¿Ð¾Ð´ÐºÐ»ÑÑÐµÐ½Ð¸ÐµÐ¼ Google Sheet Ðº Postgres Ð² Ð²Ð¸Ð´Ñ Ð¾ÑÑÑÑÑÑÐ²Ð¸Ñ JDBC Driver Postgres Ð½Ð° ÑÐµÑÐ²ÐµÑÐ°Ñ Google, Ð¿Ð¾ÑÑÐ¾Ð¼Ñ Ð±ÑÐ»Ð¸ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ñ Ð´Ð¾Ð¿Ð¾Ð»Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐµ ÑÐµÑÐµÐ½Ð¸Ñ Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Telegram bot.Ð Ð´Ð¾Ð¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ðµ Ðº Ð¾ÑÐ½Ð¾Ð²Ð½ÑÐ¼ ÑÐµÐ»ÑÐ¼ Ð±ÑÐ»Ð¸ Ð¿ÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ñ Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ñ Ð´Ð¾Ð¿Ð¾Ð»Ð½Ð¸ÑÐµÐ»ÑÐ½ÑÐµ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÑ Ð¿Ð¾ ÑÐ°Ð±Ð¾ÑÐµ Ñ Google Sheet Ð¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Ð¸ÑÐºÑÑÑÑÐ²ÐµÐ½Ð½Ð¾Ð³Ð¾ Ð¸Ð½ÑÐµÐ»Ð»ÐµÐºÑÐ°. ÐÐ°Ð´Ð°ÑÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ ÑÐµÑÐ°Ð»Ð¸ÑÑ Ð² ÑÐ¾Ð´Ðµ ÑÐ°Ð±Ð¾ÑÑ:1. ÐÑÐ±Ð¾Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¹ Ð¸ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÑÑÐµÐ´ÑÑÐ² ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸.2. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ° Ð´Ð»Ñ Google Sheet c Ð³ÐµÐ½ÐµÑÐ°ÑÐ¸ÐµÐ¹ Ð´Ð°Ð½Ð½ÑÑ Ð² ÑÐ¾ÑÐ¼Ð°ÑÐµ XML-ÑÐ¸Ð´Ð° Ð¿Ð¾ Ð¾ÑÐ´ÐµÐ»ÑÐ½Ð¾Ð¼Ñ url.3. ÐÐ±Ð·Ð¾Ñ Ð¸ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÑ ÑÐ¾Ð²Ð¼ÐµÑÑÐ½Ð¾Ð³Ð¾ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ñ Google Sheets Ð¸ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Postgres Ð¸Ð»Ð¸ Ð´ÑÑÐ³Ð¸Ñ Ð±Ð°Ð· Ð´Ð°Ð½Ð½ÑÑ.4. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÐ° Ð´Ð»Ñ Google Sheet Ð´Ð»Ñ ÐºÐ¾Ð¿Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¸ ÑÑÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ñ Google Sheet Ð² Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾ ÑÑÐµÐ´ÑÑÐ²Ð°Ð¼ JDBC Driver.5. ÐÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¸ÑÐºÑÑÑÑÐ²ÐµÐ½Ð½Ð¾Ð³Ð¾ Ð¸Ð½ÑÐµÐ»Ð»ÐµÐºÑÐ° (ÐÐ) Ñ Ð´Ð»Ñ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ð¸ Ð´Ð°Ð½Ð½ÑÑ Ð²Google Sheet.6. Ð¡Ð¾Ð·Ð´Ð°Ð½Ð¸Ðµ TÐµÐ»ÐµÐ³ÑÐ°Ð¼Ð¼ Ð±Ð¾ÑÐ° Ð½Ð° Ð±Ð°Ð·Ðµ API Ð¸ÑÐºÑÑÑÑÐ²ÐµÐ½Ð½Ð¾Ð³Ð¾ Ð¸Ð½ÑÐµÐ»Ð»ÐµÐºÑÐ° Ñ ÑÐ¾ÑÑÐ°Ð½ÐµÐ½Ð¸ÐµÐ¼ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð² Postgres.Ð§ÑÐ¾Ð±Ñ Ð½Ðµ Ð·Ð°Ð³ÑÑÐ¶Ð°ÑÑ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹ Ð¸Ð·ÑÑÐµÐ½Ð¸ÐµÐ¼ Ð´Ð¾ÑÑÐ°ÑÐ¾ÑÐ½Ð¾ Ð±Ð¾Ð»ÑÑÐ¾Ð³Ð¾ Ð¾Ð±ÑÐµÐ¼Ð° ÐÐÐ , Ð±ÑÐ»Ð¸ Ð·Ð°Ð¿Ð¸ÑÐ°Ð½Ñ Ð¸ Ð²ÑÐ»Ð¾Ð¶ÐµÐ½Ñ Ð½Ð° Ð¯Ð½Ð´ÐµÐºÑ ÐÐ¸ÑÐº [12] ÐºÐ¾ÑÐ¾ÑÐºÐ¸Ðµ Ð²Ð¸Ð´ÐµÐ¾ ÑÐ¾Ð»Ð¸ÐºÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ Ð´ÐµÐ¼Ð¾Ð½ÑÑÑÐ¸ÑÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½ÑÐµ Ð¸Ð½ÑÑÑÑÐ¼ÐµÐ½ÑÑ.
description: Topic of the graduation thesis: "Data automation and monitoring for small businesses using Google Sheets and Postgres".Objective:1. Collecting information and processing data in a Google Sheet, with the ability to generate an XML feed (product feed) for advertising.2. Saving information from a Google Sheet to a Postgres database.In the course of the work, possible methods for solving the set goals were studied. There were difficulties with connecting Google Sheet to Postgres due to the lack of JDBC DriverPostgres on Google servers, so additional solutions were proposed using Telegram bot.In addition to the main goals, additional tools were proposed and implemented for working with Google Sheet and using artificial intelligence.Tasks that were solved during the work:1. Choice of technologies and software development tools.2. Development of a tool for Google Sheet with data generation in XML feed format by a separate url.3. Overview and ability to share Google Sheets database and Postgres or other databases.4. Development of a Google Sheet tool for copying and reading data from a Google Sheet into a database using the JDBC Driver.5. Using artificial intelligence (AI) to automate data in Google Sheet.6. Creating a Telegram bot based on artificial intelligence API with saving the results in Postgres.Not noteworthy are users studying a fairly large volume of WRCs, which have been extracted and published on Yandex Disk \cite{12} and describe videos that contain the developed tools.