Development of an API or script for generating payment links and automatically sending them via SMS
I am looking for someone to create an API or script. We have a client panel for Przelewy24, where payment links can be generated. We want to automate this process: data is taken from an Excel table, payment links are automatically created based on that data, and then these links are sent to clients via an SMS gateway (SMS bramka) with the required text and payment link.
In addition, we have a panel that shows the payment status (lista transakcji), and from there, a report can be downloaded in Excel format. It is important for us that the system can also calculate the total amount of payments for each client over a certain period (for example, a month), even if the person made several separate payments (for example, in installments or continued their stay at the hostel). We need to see the total amount in one cell instead of manually summing several rows.
-
2 days217 USD
3700 17 0 2 days217 USDHello!
I am ready to start working on your order!
I am ready to implement everything quickly and, most importantly, of high quality, and help improve your service!
I will be waiting for your message in private to discuss the details!
Best regards,
Andriy!
-
3 days217 USD
23 3 days217 USDHello! I can develop the API/script you need to automate your Przelewy24 payment link generation, SMS sending, and payment reporting.
Here's a breakdown of how I'll approach each part of your project:
✅ Automated Payment Link Generation:
* Excel Data Input: I'll create a script (likely in Python, due to its excellent libraries for data manipulation and API interaction) that reads data from your Excel spreadsheet. This will include customer information and payment amounts.
* Przelewy24 API Integration: I'll utilize the Przelewy24 API to generate payment links based on the data extracted from the Excel file. This ensures secure and correct link creation.
* Error Handling: The script will include robust error handling to manage any issues with the Przelewy24 API or the Excel data.
… ✅ SMS Sending with Payment Links:
* SMS Gateway Integration: I'll integrate with your chosen SMS gateway (you mentioned "SMS bramka"). I'll need the API documentation for your specific provider. If you haven't chosen one yet, I can recommend options.
* Customizable SMS Text: The script will allow you to define the SMS text template, including placeholders for the customer's name (or other relevant data from the Excel file) and the generated Przelewy24 payment link.
* SMS Sending Trigger: The script will automatically send the SMS message after the payment link is successfully generated.
✅ Payment Status Reporting and Aggregation:
* Przelewy24 Report Download: I'll automate the download of the Excel report from your Przelewy24 "lista transakcji" panel. This may involve using web scraping techniques (if a direct API endpoint isn't available) or interacting with the Przelewy24 API if it offers report retrieval.
* Data Processing and Aggregation: The script will process the downloaded Excel report, identify payments belonging to the same client (likely using a unique identifier like a customer ID or name), and calculate the total payment amount for each client within a specified period (e.g., monthly).
* Output: The script will output the aggregated payment data, likely in a new Excel file or another easily readable format (e.g., CSV). This output will clearly show each client and their total payment amount for the period, consolidated into a single cell.
✅ Overall System Design:
* **Scheduled Execution:** I can set up the script to run automatically on a schedule (e.g., daily, weekly) using a task scheduler (like `cron` on Linux or Task Scheduler on Windows).
* **Logging:** T
-
3 days217 USD
981 17 0 3 days217 USDGood day!
I confidently work with Google Sheets. If the data is in the table, I can write a script that will generate payment links - I have created such a function for payments through Ukrainian banks. Collecting information about several payments is also not a problem. Please write, and we will discuss the details. I would like to see the table and how the link should look.
-
1 day5427 USD
8193 63 1 1 day5427 USDGood day!
I am ready to help with the implementation of your project. I look forward to the opportunity to clarify all the details and start working on it!
-
1 day4341 USD
3853 24 0 1 day4341 USDHello,
I am ready to take on your project. I specialize in automating business processes and can create an API or script for automatically generating payment links based on data from an Excel spreadsheet. I can also set up the sending of these links via SMS with the necessary text and payment link.
You already have a panel for viewing payment statuses. I will be able to develop a function to calculate the total amount of payments for each client over a certain period, so you can easily get the total amount in one cell.
My rate is $16 per hour.
Best regards,
… Maxim
-
3 days217 USD
852 15 4 3 days217 USDHello,
I am a Full-stack developer with 4 years of experience in application and service development. I am ready to help you implement your API or script. I have already worked with Przelewy24 and have an understanding of it. I know Polish well. Message me privately, and we will discuss all the details!
I look forward to collaborating with you!
Sincerely,
Maksim Alesiayuk
-
5 days217 USD
1257 34 0 5 days217 USDHello. I worked with the Przelewy24 system. I will develop the necessary functionality.
Feel free to contact me.
-
2 days217 USD
99 0 2 2 days217 USDGood afternoon, I can make you a script, I am from Poland and it will be easier for me since I have already worked with this, I am a developer with 4 years of experience, I will easily be able to make you such a script.
-
2 days217 USD
2225 32 0 2 days217 USDGood day. I have already made such a script in Python. I can do it. It will work on Windows, Linux, and macOS. We need to discuss the details. I know Polish.
-
4 days217 USD
1872 9 0 4 days217 USDGood day!
I am ready to develop an automated solution for integration with Przelewy24 for you. I propose to create an API or script that:
- Will automatically generate payment links based on data from an Excel file.
- Will send SMS messages to clients via the chosen SMS gateway, including text with the payment link.
- Will receive and analyze transaction data – will calculate the total amount of payments for each client over a certain period and store this data in a convenient format.
- Will automate the reporting process – will create summary tables that simplify payment control.
I have experience working with payment system APIs, automating Excel file processing, and integrating SMS gateways. I am ready to discuss your requirements in detail and propose an optimal solution.
…
I look forward to collaborating!
-
4 days217 USD
1317 23 0 4 days217 USDGood afternoon. I am ready to implement such a script. Let's get in touch and discuss the details.
-
1 day217 USD
94294 1269 1 10 1 day217 USDHello. I have extensive experience with Node.js/Python. Ready to collaborate.
-
3 days217 USD
10063 117 0 3 days217 USDHello.
I am a NodeJS developer. I am ready to take it on. Write to me, we will discuss.
-
2 days217 USD
626 6 0 2 days217 USDHello, I am interested in your offer, I have made a similar bot for Telegram but I can also implement it as a script, let's discuss this in private messages.
Current freelance projects in the category Databases & SQL
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 22 hours 26 minutes back ∙ 14 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 3 days 2 hours back ∙ 55 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 3 days 2 hours back ∙ 13 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 3 days 15 hours back ∙ 10 proposals |
Database synchronizationSynchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 3 days 21 hours back ∙ 12 proposals |