- 5
- 5 931
Cover4Tech
Приєднався 21 вер 2021
Welcome to Cover4Tech, your friendly tech guide! Our mission is to simplify technology for everyone, whether you're a seasoned tech enthusiast or just beginning your journey. Our videos encompass a variety of topics, from leveraging cryptocurrency in Google Sheets to seamlessly connecting your phone's VPN to your PC over Wi-Fi. We break down complex tech concepts into easy-to-follow steps and offer practical tips. Our tutorials are crafted to enhance your tech usage, making it more efficient and secure. At Cover4Tech, we empower you to tackle tech challenges with ease and confidence. Join our community to evolve into a tech expert while enjoying the wonders of technology. Subscribe to Cover4Tech and start your journey towards becoming tech-savvy today!
How to Set Up a VPN on Your Linux Server for Your Android Phone
In this video, you will learn how to build a VPN on your Linux server and connect your Android phone to it. By doing this, you can use your server's IP address on your mobile device, allowing you to browse the internet securely and privately as if you were directly connected to your server. This is a great way to use your Linux server as a VPN for your smartphone.
Commands:
docs.google.com/document/d/1pIt12iGxJAATDl0MkyNcFl0zRBhKP0-8f7zFYBHHz4w
Commands here:
sudo apt update
sudo apt upgrade openssh-server
sudo nano /etc/ssh/sshd_config
# Add or modify lines:
# PasswordAuthentication yes
# Ciphers aes128-gcm@openssh.com,aes128-ctr
sudo systemctl restart sshd
sudo apt-get install iptables-persistent
sudo ufw allow 1080/tcp
sudo netfilter-persistent save
sudo reboot
if problem:
sudo nano /etc/sysctl.conf
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1
sudo sysctl -p
sudo reboot
Commands:
docs.google.com/document/d/1pIt12iGxJAATDl0MkyNcFl0zRBhKP0-8f7zFYBHHz4w
Commands here:
sudo apt update
sudo apt upgrade openssh-server
sudo nano /etc/ssh/sshd_config
# Add or modify lines:
# PasswordAuthentication yes
# Ciphers aes128-gcm@openssh.com,aes128-ctr
sudo systemctl restart sshd
sudo apt-get install iptables-persistent
sudo ufw allow 1080/tcp
sudo netfilter-persistent save
sudo reboot
if problem:
sudo nano /etc/sysctl.conf
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1
sudo sysctl -p
sudo reboot
Переглядів: 45
Відео
How to Send Telegram Messages from Google Sheets: Automate Posting with Bots and Time-Driven Trigger
Переглядів 16521 день тому
In this video, I will guide you through two powerful methods to automate sending messages from Google Sheets to a Telegram channel using bots. First, you'll learn how to send all the content from column A of Sheet1 to your Telegram channel in one go. Then, I'll show you how to automate the process by scheduling messages to be sent one by one at specific intervals, such as every minute, 15 minut...
Google Sheets vs Microsoft Excel: Which is Better?
Переглядів 754 місяці тому
Are you trying to decide between Google Sheets and Microsoft Excel for your spreadsheet needs? In this video, we compare these two powerful tools, examining their features, ease of use, collaboration capabilities, and overall performance. Whether you're a student, a professional, or a small business owner, this in-depth comparison will help you make an informed decision on which platform suits ...
how to import crypto price into google sheets
Переглядів 7129 місяців тому
Discover the seamless process of importing cryptocurrency prices into Google Sheets. This comprehensive guide provides you with step-by-step instructions on how to effortlessly pull real-time crypto prices into your Google Sheets, enabling efficient tracking and analysis. Whether you're a crypto enthusiast, an investor, or simply someone looking to understand the dynamics of cryptocurrency mark...
Import Data from Any Website into Google Sheets
Переглядів 4,9 тис.9 місяців тому
Discover how to import data effortlessly from websites directly into your Google Sheets. This tutorial guides you through the process of fetching information from popular financial websites like Investing.com and Yahoo Finance, enabling you to pull data into Google Sheets. Learn the tricks to set up your sheets to update automatically, ensuring your financial data is always current. Whether you...
Can messages be sent to watsapp also?
Yes but i think WhatsApp needs api key
Didn't work for me. I get a message to request permissions. Then after I get an error Could not fetch url: (the url)
Some URLs are not fetchable due to various reasons. One common reason is that the website administrator prevents scraping and instead offers access through a paid API.
How to identify the (index)number of the table or list in inspect element?
By trying different numbers
how about websites that require login? is it posible to use this method? i appreciate for your help
That would need advanced features which will be introduced
hello could this allow me to recover data from my Amazon seller account and also to recover the titles of public UA-cam videos?
The advanced features can do the log in required data, but for UA-cam there are different options
@@Cover4Tech ok can you tell me how is there a tutorial from google or other? could I send u an email
How does the google sheet binance?
Follow this GitHub instructions, you can import binance data into your Google sheet: github.com/diegomanuel/binance-to-google-sheets
?????? From any Website ???????? When the data isn't in a "TABLE" how do you import that? When the data isn't in a "LIST" how do you import that? What I need is to be able to import a web page after I open it on another tab ( have to login ) Also over time as I've explored various websites more and more tables are being formatted via CSS and not a table or list. What needs to be explained is how to import from those types of webpages. There are examples all over the place for those import functions in google sheets.
This is basic feature of Google sheet web scraping, I will record another video to show the advanced feature of Google sheets+ Google apps script
I'm having this same problem, did you find a solution?
@@nateridgard5773 The advanced features will be presented in the channel
@@nateridgard5773 the advanced features will be presented in the channel
@@nateridgard5773 Well I see he says answer will be presented in the channel. Because he's not posted a link to the indicated solution I'd say that there is no solution as of yet.
thanks
You are very welcome
Thank you for sharing... Question, How does the google sheet updatew with the latest price?
You are welcome, by refreshing the Google sheet. Also you can do it by changing the settings of Google sheet in file menu and change the time of updating to every minutes.
Promo sm 🤔