Jul 5, 2018

How to Block Jio from Showing Ads on your Android Phone

Ever since I added the Reliance Jio 4G SIM on my Android phone, I’ve been bombarded with fullscreen overlay ads. The ads appear intermittently but they’ll almost always show up after you disconnect a phone call or when you are charging the device.

reliance-jio

I use a limited number of Android apps from known developers and was fairly certain that adware was related to the Jio phone service. After fiddling with every possible setting inside Android to disable the ads, I turned to Twitter for help.

You can read the entire Twitter thread or here’s a quickly summary:

  1. Uninstall MyJio, Jio 4G Voice and all other Jio apps.
  2. Revoke all permissions of Jio apps. Long press the app icon, press the info button, go to App Permission and uncheck everything. Also turn off the “draw over the apps” permission for Jio apps.
  3. For Android Oreo or later, go to Settings > Apps > MyJio and turn off the “App can appear on top” setting. You probably need to do this for every Jio app on the device.
  4. Root the phone and install AdAway, an ad block that uses the hosts file to block specific hostnames and IP addresses.
  5. Use Greenify to hibernate all the Jio apps and prevent the app from running in the background.
  6. Disable ‘Telephone’ access for all Jio apps. Even Jio Mags has default access to ‘Telephone’!
  7. Toggle background data to disable data access for all Jio related apps.

Unfortunately, none of these suggestions worked.

Meanwhile, the Jio team contacted me after seeing the tweet and asked for the IMEI number of the phone. A week later, I got a call from the Jio support team saying that the problem should be resolved.

Yes, I was no longer getting any pop-up ads on my phone despite having all the Jio apps as before. What changed? It turned out, the Jio support representative told me, that these ads can only be disabled by Jio for the requested phone number on the server side.

In short, if you are also feeling annoyed with Jio related ads on your phone, send a tweet to @JioCare and they should be able to help. This also reminds me of Amazon – just ping their support team and they’ll happily remove ads from your Kindle.

The post How to Block Jio from Showing Ads on your Android Phone appeared first on Digital Inspiration.



via Digital Inspiration Technology Blog https://ift.tt/2ziQUZY

How Attachment Reminders work inside Gmail?

Gmail has a built-in feature that reminds you of adding file attachments before the email is sent to the recipient. Gmail scans the text of your email and shows an alert if it thinks you intended to include a file attachment in the message but forgot to do so.

gmail-attachment.gif

If you haven’t seen this earlier, compose a new email in Gmail, add “I’ve attached the file” in the body and hit send. Gmail will pop-up a warning saying – “it seems like you forgot to attach the file.”

How does the forgotten attachment detector work inside Gmail? I was looking at the source code of Gmail.com using Chrome Dev Tools and found an interesting snippet that bares it all.

gmail-source-code.png

When you hit the send button, Gmail scans the text of your outgoing message and looks for the following word combinations using regex.

|see attached|see attachment|see included|is attached|attached is|are attached|attached are|attached to this email|attached to this message|I’m attaching|I am attaching|I’ve attached|I have attached|I attach|I attached|find attached|find the attached|find included|find the included|attached file|see the attached|see attachments|attached files|see the attachment

If a match is found, a warning is shown so you’ll never forget to include that important attachment again.

Microsoft Outlook too includes an attachment detector feature and, unlike Gmail, it also provides you an option to define custom keywords that should trigger the missing attachment alert.

Also see: Download Gmail Attachments to Google Drive

The post How Attachment Reminders work inside Gmail? appeared first on Digital Inspiration.



via Digital Inspiration Technology Blog https://ift.tt/2MO5jiN

Jun 4, 2018

The 101 Most Useful Websites on the Internet

Here are the most useful websites on the Internet that will make you smarter, increase productivity and help you learn new skills. These incredibly useful websites solve at least one problem really well. And they all have cool URLs that are easy to memorize thus saving you a trip to Google.  

101 Useful websites

The Most Useful Websites and Web Apps

  1. archive.is — take a snapshot of any web page and it will be exist forever even if the original page is gone.
  2. autodraw.com — create freehand doodles and watch them magically transform into beautiful drawings powered by maching learning.
  3. fast.com — check the current speed of your Internet connection.
  4. slides.com — create pixel-perfect slide decks and broadcast your presentations to an audience of any size from anywhere.
  5. screenshot.guru — take high-resolution screenshots of web pages on mobile and desktops.
  6. dictation.io – accurate and quick voice recognition in your browser itself.
  7. reverse.photos — upload an image and find similar pictures on the web.
  8. copychar.cc – copy special characters and emojis that aren’t on your keyboard.
  9. codeacademy.com – the best place to learn coding online.
  10. noisli.com — ambient noises to help you improve focus and boost productivity.
  11. iconfinder.com – millions of icons for all kinds of projects. Also try icons8.com and flaticon.com.
  12. jotti.org – scan any suspicious file or email attachment for viruses.
  13. wolframalpha.com – gets answers directly without searching   – see more wolfram tips.
  14. flightstats.com – track flight status at airports worldwide.
  15. unsplash.com – the best place to download images absolutely free.
  16. videos.pexels.com — an online library of free HD videos you can use everywhere. Also see videvo.net.
    Also see: The Best Android Apps
  17. everytimezone.com – a less confusing view of the world time zones.
  18. e.ggtimer.com – a simple online timer for your daily needs.
  19. random.org – pick random numbers, flip coins, and more.
  20. earn.com — replace your email with a mailbox that pays when you reply to someone’s email.
  21. myfonts.com/WhatTheFont – upload an image of any text and quickly determine the font family.
  22. fonts.google.com – the best collection of open source fonts that you can use anywhere without restrictions.
  23. fontstruct.com — draw and build your own fonts and use them in any application.
  24. calligraphr.com — transform your handwriting into a real font.
  25. regex.info – find data hidden in your photographs – see more EXIF tools.
  26. youtube.com/webcam — broadcast yourself live over the Internet without any complicated setup.
  27. remotedesktop.google.com — access other computers or allow others to remote access your computer over the Internet.
  28. homestyler.com – design from scratch or re-model your home in 3D.
  29. pdfescape.com – lets you quickly edit PDF in the browser without Acrobat.
  30. draw.io – create diagrams, wireframe and flowcharts in the browser.
  31. web.skype.com — make voice and video calls in your browser with Skype.
  32. onlineocr.net – recognize text from scanned PDFs – see other OCR tools.
  33. wetransfer.com – for sharing really big files online.
  34. file.pizza — peer to peer file transfer over WebRTC without any middleman.
  35. snapdrop.com — like Apple AirDrop but for the web. Share files directly between devices in the same network without having to upload them to any server first.
  36. hundredzeros.com – the site lets you download free Kindle books.
  37. app.grammarly.com — check your writing for spelling, style, andgrammatical errors.
  38. noteflight.com – print music sheets, write your own music online ( review).
  39. translate.google.com – translate web pages, PDFs and Office documents.
  40. kleki.com – create paintings and sketches with a wide variety of brushes.
  41. similarsites.com – discover new sites that are similar to what you like already.
  42. bubbl.us – create mind-maps, brainstorm ideas in the browser.
  43. color.adobe.com – get color ideas, also extract colors from photographs.
  44. canva.com — make beautiful graphics, presentations, resumes and more with readymade template designs.
  45. lmgtfy.com – when your friends are too lazy to use Google on their own.
  46. midomi.com – when you need to find the name of a song.
  47. history.google.com —  see all your past Google searches, also among most important Google URLs
  48. faxzero.com – send an online fax for free – see more fax services.
  49. tinychat.com – setup your own private chat room in micro-seconds.
  50. privnote.com – create text notes that will self-destruct after being read.
  51. domains.google.com – quickly search domain names for your next big idea!
  52. downforeveryoneorjustme.com – find if your favorite website is offline or not?
  53. gtmetrix.com – the perfect tool for measuring your site performance online.
  54. builtwith.com — find the web hosting company, email provider and everything else about a website.
  55. urbandictionary.com – find definitions of slangs and informal words.
    Also see: The Best Mac Apps and Utilities
  56. seatguru.com – consult this site before choosing a seat for your next flight.
  57. flightstats.com – Track flight status at airports worldwide.
  58. mymaps.google.com – create custom Google Maps with scribbles, pins and custom shapes.
  59. snopes.com – find if that email offer you received is real or just another scam.
  60. typingweb.com – master touch-typing with these practice sessions.
  61. todo.microsoft.com — a beautiful todo app and task manager. Also see Trello.
  62. minutes.io – quickly capture effective notes during meetings.
  63. talltweets.com — Turn Google Slides in animated GIF presentations.
  64. ifttt.com – create a connection between all your online accounts.
  65. namechk.com — search for your desired username across hundreds of social networks and domain names.
  66. gist.github.com — create anonymous and secret text notes and much more.
  67. flipanim.com — create flipbook animations, includes an onion skin tool to let you see the previous frame as you draw the next one.
  68. powtoon.com — create engaging whiteboard videos and presentations with your own voiceovers. Also see videoscribe.co.
  69. clyp.it — Record your own voice or upload an audio file without creating any account. Also see soundcloud.com.
  70. carrd.co — build one-page fully responsive websites that look good on every screen.
  71. spark.adobe.com — make stunning video presentations with voice narration and wow everyone.
  72. anchor.fm — the easiest way to record a podcast that you can distribute on iTunes without have to pay for hosting.
  73. duolingo.com — learn to speak Chinese, French, Spanish or any other language of your choice.
  74. webmakerapp.com — an offline playground for building web projects in HTML, CSS and JavaScript.
  75. pixton.com — create your own comic strips with your own characters and move them into any pose.
  76. designer.io — a full-featured vector drawing tool that works everywhere.
  77. sumopaint.com – an excellent layer-based online image editor.
  78. vectr.com — create vector graphics and export them as SVG or PNG files.
  79. twitterbots — create your own Twitter bots that can auto-reply, DM, follow people and more.
  80. headspace.com —  learn the art of meditation and reduct stress, focus more and even sleep better.
  81. class-central.com — a directory of free online courses offered by universities worldwide.
  82. googleartproject.com — discover museums, famous paintings and art treasure from all around the world.
  83. instructables.com — step-by-step guides on how to build anything and everything.
  84. flowgram.com — make data-driven graphics, charts and infographics. Also see adioma.com and eas.ly.
  85. marvelapp.com — create interactive wireframes and product mockups.
  86. slide.ly — make marketing videos and branded stories for Instagram, Facebook and YouTube trailers. Also see animoto.com and biteable.com.
  87. gohighbrow.com — Take bite-sized courses on a variety of topics, chapters are delivered by email every monning.
  88. htmlmail.pro – send rich-text emails with gmail mail merge.
  89. wirecutter.com — whether you need a vacuum cleaner or an SD card, this is the best product recommendation website on the Internet.
  90. camelcamelcamel.com — Create Amazon price watches and get email alerts when the prices drop.
  91. mockaroo.com — download mock data to fill the rows in your Excel spreadsheet.
  92. asciiflow.com — a WYSIWYG editor to draw ASCII diagrams that you can embed in emails and tweets.
    Also see: The Best Add-ons for Gmail, Docs and Sheets
  93. buffer.com — the easily way to post and schedule updates on Twitter, Instagram, LinkedIn, Google+ and Facebook.
  94. 10minutemail.com — create disposable email addresses for putting inside sign-up forms.
  95. whereami — find the postal address of your current location on Google maps.
  96. sway.com — create and share interactive reports, newsletters, presentations, and for storytelling.
    Also see: The Best Websites to Learn Coding
  97. apify.com — the perfect web scraping tool that lets you extract data from nearly any website.
  98. thunkable.com — build your own apps for Android and iOS by dragging blocks instead of writing code. Also see: glitch.com.
  99. zerodollarmovies.com — a huge collection of free movies curated from YouTube.
  100. upwork.com — find freelancers and subject experts to work on any kind of project.
  101. duckduckgo.com – a clean alternative to google search that doesn’t track you on the Internet.

Know any useful website that is missing in the list? Please let me know via @twitter or send an email.

The post The 101 Most Useful Websites on the Internet appeared first on Digital Inspiration.



via Digital Inspiration Technology Blog https://ift.tt/2lzHcXx

May 29, 2018

How to Screen Capture Tweets with a Twitter Bot

Introducing Screenshot Guru, a new Twitter bot that will help you easily take high-resolution screenshots of tweets. There are a plethora of screen capture apps available, including the good old Print+Screen combo but with Screenshot Guru, you get crisp and beautiful screenshots sans the clutter.

Screenshot Guru offers 3 different options for screen capturing tweets. You have a web app for desktops, a Google Chrome extension and a Twitter bot @screenshotguru for people who are looking for a way to easily screenshot tweets on their Android or iPhone.

Let’s explore in more detail.

1. Web App – Go to screenshot.guru and type the URL of any web page or tweet that you would like to save as a PNG image. Solve the CAPTCHA and you’ll have a crisp retina screenshot ready in a second or two.

2. Chrome Extension – Install the Twitter Screenshots addon from the Google Chrome store and then switch to the Twitter website. You’ll see a little camera icon in every tweet – click the icon and it will instantly transform the tweet into a high-res PNG screenshot that will exist forever even if the original tweet is gone.

twitter-screenshots.png

3. Twitter Bot – Screenshot Guru is available as a Twitter bot that works both on the Twitter website and mobile apps. You can DM tweets to the @screenshotguru bot and it will send a screenshot image back to you in a private DM.

Sending a tweet via DM is easy (watch video tutorial). Tap on the share icon from a tweet on your Twitter timeline and then tap “Send via Direct Message”. Type screenshotguru as recipient account and tap the Send icon.

The Screenshot Guru app is written in Node.js and hosted on the Google Cloud Platform. The screen captures are done through headless Chrome (Puppeteer) while the images are stored on Google Cloud Storage. The Twitter Bot is running on Google App Engine.

Also see: Write your own Twitter Bot

The post How to Screen Capture Tweets with a Twitter Bot appeared first on Digital Inspiration.



via Digital Inspiration Technology Blog https://ift.tt/2JhJ9rm

May 22, 2018

Read This Before You Buy Any Udemy Course

Looking to learn coding this summer? Well, there are plenty of free resources on the Internet to quickly get you started but if you prefer proper instructor-led video courses, go with Udemy. If you are new here, Udemy is an online marketplace where you’ll find courses on everything from calligraphy to photography to programming.

I’ve purchased more than two dozen Udemy courses around web development from different instructors – the list includes courses on React, Redux, JavaScript, Node.js, ES6, Express, Webpack, Firebase, TypeScript – and have been really impressed with the overall quality of the training content. You pay a one-time fee for any course and, unlike Pluralsight or Lynda LinkedIn Learning that charge a monthly subscription, your Udemy course will be yours forever.

Most video courses on Udemy are priced between $20 and $200 but before you key in the credit card, ready this.

Avoid Impulse Buying

Udemy offers massive discounts almost every week and the $150 course you are looking to buy could be available for as low as $10 the next day, or even the next hour.

Do not make ‘impulse’ purchases on Udemy. Add the Udemy course to your wish list or place it in your shopping cart and you could soon have an email from Udemy itself saying that course has gone on sale.

Support the Instructor

Udemy has a simple revenue-sharing agreement with instructors. If the instructor brings the student to Udemy through their own links, Udemy’s commission is mere 3% of the sale price. If a student finds a course by directly searching on Udemy, the instructor’s share is only 50% of the sale.

Check the blog, Twitter or Facebook pages of the Udemy teacher. Buy the course through links shared by Udemy teachers on their social media pages and you’ll be indirectly helping them as they’ll get most of the sale proceeds.

Avoid Coupon Sites

Search for “Udemy Discount Coupons” on Google and a million websites will pop-up. The problem is the 99.9% of these sites offer outdated/expired coupons and their sole purpose is to serve ads or get their own cookie in your browser.

Use Browser, not Mobile Apps

You can buy Udemy courses on their website or through their mobile apps. The interesting thing is that the same course may be priced differently depending on the platform you are on. It’s just like some airline company showing higher prices to people who are browsing on an iPhone.

I simultaneously searched for React.js courses on Udemy on iOS, Android, and Chrome and the prices varied everywhere. The prices displayed were lowest when I opened Udemy on the desktop in Chrome’s incognito mode.

Udemy Website on Chrome

udemy-user

Udemy Android App

udemy-android

Udemy iPad App

udemy-ios-ipad

Udemy Website – Incognito mode

udemy-incognito

The bottom line is that you should never purchase Udemy courses at the list price and always use a desktop to complete the purchase. They probably have to pay Google / Apple a share in the sale and hence the courses are priced higher inside Udemy’s mobile apps.

The post Read This Before You Buy Any Udemy Course appeared first on Digital Inspiration.



via Digital Inspiration Technology Blog https://ift.tt/2s31nlI

Apr 26, 2018

How to Backup your Gmail Inbox to another Gmail Account

Looking for an easy way to backup your Gmail messages? The Download Gmail add-on automatically saves a copy of your Gmail emails and file attachments to your Google Drive. You can then use the Drive client to backup the files saved in Drive to your local Windows PC or Mac.

The little downside with this approach is that Gmail and Google Drive share common storage space. So if you archive an email thread that contains, say, a 10 MB file attachment, the email will end up consuming 20 MB overall space in your Google Storage (10 MB in Gmail and another 10 MB in Drive).

Move Gmail Data from One Google Account to Another

If your current Gmail account is running low on storage, you can consider using a new Gmail account to backup your existing emails and then delete the bulky mails from the primary account to make space. There are no addons to install and the Gmail-to-Gmail transfer happens directly in the cloud.

gmail-import-emails.png

Let’s get started.

Create a new Gmail account for backup, go to Settings, select the Accounts and Import tab and choose Import Mail and Contacts.

In the pop-up window, specify the email address of your existing @gmail.com account from where you wish to import the messages into the new account.  Sign-in with your credentials and allow the ShuttleCloud app to access your Gmail and Google contacts data.

Once the authentication is successful, click the “Start Import” button to begin the migration. You can close this window or even log out and close your browser as the import happens in the cloud.

gmail-migration.png

After all the emails are imported, you’ll find a new label in your new Gmail account that will house all the imported emails. The folder structure of the source email account is replicated under this new label.

Google has integrated a third-party vendor – ShuttleCloud – to handle the email migration within Gmail. As per their privacy policy, they do not store any copies of your emails nor do they use your personal information in any way.

Once the migration is complete, you can visit myaccount.google.com/permissions and revoke access to the service. Also, since the authentication happens via Google OAuth, you don’t have to share your password anywhere.

PS: If you are looking to backup your GSuite emails to another Gmail account, please follow this email migration guide.

The post How to Backup your Gmail Inbox to another Gmail Account appeared first on Digital Inspiration.



via Digital Inspiration Technology Blog https://ift.tt/2Fi96Rj

How to Copy Email Messages from GSuite to a New Gmail Account

Your current organization uses GSuite, formerly knowns as Google Apps, with Gmail for email. You are moving to another company and would like to archive all your existing email messages before they are permanently deleted from the Google servers.

Our previous email migration guide discussed ShuttleCloud, a service built into Gmail that uses Gmail APIs to copy your emails from one Gmail account to another. That approach will, however, not work when you are transferring emails from GSuite to a standard Gmail account.

How to Copy GSuite Emails to another Gmail Address

Step 1: Enable POP

In your old Gmail (GSuite) account, go to Settings, click the Forwarding and POP/IMAP tab, choose Enable POP for all mail in the POP download section and save your changes.

Gmail POP Access

Step 2: Generate password

While modern apps work with the OAuth protocol that do not require you to share your Gmail password with third-party apps, the POP3 protocol needs your password in plain text to download your emails.

While you are logged into the old Gmail account, go to google.com/apppasswords, choose Custom from the Select App drop-down, enter a name (like Download Gmail through POP) and generate the app-specific password.

Gmail Password Screen

Step 3: Transfer Email

Open a new browser tab and sign-in with your new Gmail account. Next, go to Settings, click the Accounts and Import tab, and choose Import mail and contacts. In the pop-up window, enter the full email address of your old Gmail account hosted on Google Apps (GSuite). Click Continue.

In the next step, enter the app-specific password of your old Gmail account that you’ve generated in the previous step. The POP username is the same as your email address while the pop server is pop.gmail.com. Choose port 995 and enable the “Use SSL” setting.

gmail-pop-settings.png

Enable the settings “Leave a copy of retrieved messages on the server” and “Label incoming messages” to easily identify emails fetched from the old address. Click “Start Import”  and Gmail will immediately start copying your old messages to your new email address.

That’s it. The process may take a while to complete based the size of your mailbox. The email transfer happens in the cloud so may safely close your browser.

PS: This method is recommended for transferring the entire mailbox to another email account. If you would like to transfer a select number of email messages, look at the Gmail bulk email forwarder.

The post How to Copy Email Messages from GSuite to a New Gmail Account appeared first on Digital Inspiration.



via Digital Inspiration Technology Blog https://ift.tt/2jm9Rmz

Feb 27, 2018

How to Record your Android Screen with the YouTube Gaming App

YouTube’s gaming platform, available at gaming.youtube.com, primarily focuses on live streaming of video games. It may not have an audience as large as Amazon’s Twitch TV but there exist a few unique features that make the YT Gaming app useful for everyone, not just professional gamers.

One, you don’t need additional hardware or software to live stream your games to YouTube. You can do a quick live stream from your desktop as well as your mobile phone. And the most interesting part, YT Gaming isn’t just for recording gameplay but can be used to record screencasts of any app on your Android phone.

How to Record Screencasts on Android with YouTube

Here’s a step by step guide on how to create screencasts on your Android phone via the YouTube app. Standalone screencasting apps may offer more features but with YT Gaming, the big benefit is that you can even live stream your phone on to YouTube with a tap. The app is free and there are no ads. Let’s get started.

Android Screencast with YouTube

Launch YT Gaming on Android and click the Go Live button. You may choose to live stream your phone directly or record the screencast first, edit the video and then upload it to YouTube.

One the next screen, select an Android App that you’d like to stream. YT Gaming will show a list of apps that fit in the ‘gaming’ category but can you click the ‘All Apps’ link to screencast any app that’s installed on your Android phone.

The recorder will stream everything you do while the session is on including incoming notifications and the text you type in input boxes. Also, it will record the audio from the speaker as well as surrounding sound though you do get an option to mute the microphone. The front camera can be turned off as well.

video-screencast-editor.jpg

After you are done recording, swipe down the notification drawer and tap to stop the session. You can now perform basic video editing before uploading the video to YouTube. For instance, you can replace the ambient audio with background music, trim the video or apply video effects like sepia, B&W and more.

That’s it. Your screencast video is now ready to share with the world.

Also see: How to Create Screencasts with YouTube



via Digital Inspiration Technology Blog http://ift.tt/2EXj2oc

Feb 22, 2018

How to Make Pixel Paintings with Google Spreadsheets

You are using Google Spreadsheets for budgeting and project management but did you know that the same sheets application can help you create impressive pixel paintings in minutes? The Google blog recently published a story of two illustrators who created a bright and beautiful wall mural using Google Spreadsheets.

Marina and Mallory connected on Google Hangouts to plan and sketch out ideas, and creatively “hack” Sheets in order to make art: resizing cells into thousands of pixel-like squares, merging cells to create color blocks, creating vibrant color gradients with conditional formatting and cell values, and other cool things we had no idea you could do with Sheets.

The idea is simple. Each cell in the spreadsheet corresponds to a pixel in the painting. You compute the color of the pixel and make it the background color of the corresponding cell. Now resize the spreadsheet cells in small perfect squares and your spreadsheet will look exactly like the original artwork.

How to Paint with Google Spreadsheets

If you would like to create your own spreadsheet art but don’t have the time to carefully paint every cell manually, here’s a simple workaround for you. You can take any photograph, vector art, or any other image and use a Google Script to convert that bitmap image into spreadsheet art.

Here are some examples of art created with Google Spreadsheets.

Watch the video tutorial or open this Google Sheet for sample artwork.

Create Pixel Art with Google Sheets

It takes two easy steps to make pixel art with Google Sheets.

  1. Open the Google Spreadsheet template and create a copy of the sheet in your own Google Drive.
  2. Go to the Spreadsheet Art menu and upload the image from your desktop. You can use images of any size or resolution.

The underlying Google Script will now parse every single pixel of your image and write the corresponding hex color codes in the cells of the spreadsheet.

It will then set the background color of every cell same as the color of the corresponding pixel. If you have chosen the ’emoji’ option, the cell will be filled with the closes emoji that matches the color of the pixel.

In the last step, the script will resize the cells and turn them into perfect squares. That’s it. Your spreadsheet art is now ready.

The latest version of the Spreadsheet Art project can transform your pictures into emojis pixels as well. It takes the average color of the pixel, finds the closest emoji and adds it to the corresponding cell in the sheet. The emoji module is based on the work of Monica Dinculescu.

The end result may appear slightly pixelated (video) because we have used a small image as the source template but impressive nonetheless. You can download the Google Sheet as a PDF file or save it in Microsoft Excel format.

Check this Google Sheet for more examples.



via Digital Inspiration Technology Blog http://ift.tt/2BIEudx

Feb 20, 2018

How to Keep your Folders on FTP Server and Google Drive in Sync

How do you connect an FTP server to your Google Drive or Dropbox for transferring files in either direction automatically?

Well, the easiest option would be to use a desktop FTP client like Cyberduck (supports Mac & Windows, free) or Transmit (Mac only, paid). These software applications can connect to all the popular cloud storage services including Google Drive, OneDrive, Dropbox and Amazon S3. They can perform a remote-to-remote sync allowing you to recursively transfer files and folders from the FTP server to any cloud service and vice versa.

The only issue with using a desktop application is that it needs to be run manually on your computer. Wouldn’t it be nice if you could set up a task that continuously monitors your Google Drive (or Dropbox or OneDrive) for new files and automatically copies them to a specified FTP server?

Transfer Files from FTP Server to Google Drive

Enter Microsoft Flow, an online automation service that lets you create automated workflows similar to Zapier and IFTTT. The free plan lets you create unlimited workflows and each workflow would run every 15 minutes. And it is the only service in town that can simultaneously talk to Google Drive, OneDrive, Dropbox and FTP /SFTP servers.

google-drive-ftp.png

Let’s create a connector that will upload a copy of the file to Google Drive whenever a file is added to Google Drive. You can similarly setup workflows to sync files from a folder in Dropbox to folder on FTP server. Or connect to Gmail and download emails to your FTP server automatically in the background.

  1. Go the Microsoft Flow Connectors page and activate the FTP (or SFTP) service.
  2. Next select the trigger that should start the workflow. In our case, we’ll choose “When a file is added to the FTP server”
  3. Specify the host address, the username and the password for your FTP server. If you are using SFTP, you may also need to specify the SSH private key and passphrase.
  4. On the next screen specify the full path of the folder on the FTP server that should be monitored for new files.
  5. Click “Add an Action” for the New step, choose Google Drive from the connector list and set the action as “Create File”
  6. Select the folder in Google Drive where the files should be saved, set the file name and file content fields from the list of available files so they match the incoming file name and content.

Save the flow and test. Also checkout the documentation page to know about the various actions and triggers available for the FTP / SFTP connectors in Mcirosoft Flow.



via Digital Inspiration Technology Blog http://ift.tt/2BFVt0b