Importing data from gmail letters about income/expenses on your bank account
27 USD Make CashFlow
Introduction to:
The task 1
For each transaction on the bank account comes an email to gmail, with information about:data/signature Contractant (payer)other unnecessary informationWith Zapier you can set the upload of these data in Google Sheets.
Here I can’t make this loading that would work automatically and stable.
Task No. 2
In Google Sheets remove using the formula “excessive” to leave what you need.
An example of what I would like to set up by task No. 1 and No. 2 in the insert in the screens.
Applications 2
Client's review of cooperation with freelancer
Importing data from gmail letters about income/expenses on your bank accountIt was a pleasure to work with Anton.
Qualitative work with explanations.
The work is done quickly, in time and with explanations how and what works.
I am satisfied and I recommend!
Freelancer's review of cooperation with Sergey Shimkovich
Importing data from gmail letters about income/expenses on your bank accountThe first collaboration within a small project was successful. The task was quite detailed, and all necessary clarifications and additional data were provided in time. Communication was, in fact, sufficiently informative and detailed. The verification of the results and confirmation of the performance of the task were done quickly. I recommend Sergey as an adequate customer.
-
14 days335 USD
209 14 days335 USD
Hello to you.
The company TOV "Business" is ready to take over your project. Details on our website https://businessoft.com.ua If necessary, we will sign the contract.
with respect,
by Yuri Bukinsky.
-
для дальнейшей работы с этими данными.
Если счёт один, то, по-моему, проще будет выписку импортировать, разве нет?
Альфа - конечно, не Приват, и API не выставляет, чтоб это можно было прямолинейно закодировать, но на крайний случай можно и через AutoIt автоматизировать.
-
Антон, здравствуйте.
Строим CashFlow - это фин отчет, в который капают данные на ежедневной основе о приходах/расходах с текущего счета в банке.
Выглядит вот так: http://prntscr.com/pb5d3d
-
Спасибо за пояснения.
В Google Sheets данные можно вносить через API (см. пример на .NET). Если из банка выписку невозможно получить в автоматическом режиме, то и почту можно анализировать тоже через подобное API. В результате получится приложение (напр., для Windows с использованием .NET), которое читает почту и обновляет таблицу.
В принципе, можно и напрямую закодировать на Google Apps Script - будет работать в браузере.
Вам какой вариант больше подходит?
-
API это значит надо будет получать ключи и в gmail и в Google Sheets.
Проще выглдяит Google Apps Script, что бы каждые 15-30 минут проверял почту и в случае, если найдет подходящее письмо, выгружал из него нужные данные (название платильщика, сумму, дату, остаток). Всю другую инфо не выгружал.
-
Current freelance projects in the category Desktop Apps
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 13 hours 21 minutes back ∙ 7 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 1 day back ∙ 5 proposals |
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 8 days 14 hours back ∙ 10 proposals |
Development of custom software (Android application + CMS) for SUNMI K2 self-service kiosks (Fast food)
22 USD
We are looking for an experienced team or a Middle/Senior Android developer (possibly with Full-stack skills) to create proprietary software for self-service kiosks for a fast food retail chain. Currently, our terminals operate on a ready-made cloud integrator, but we are… Content Management Systems, Desktop Apps ∙ 13 days 10 hours back ∙ 23 proposals |
Kyiv