YOUR SUCCESS IS OUR SUCCESS!

Review Us on

Lindsay Bowen Avatar
Lindsay Bowen
7/18/2019 - Google

Thanks to Blackstorm design & marketing we have got our website ranking at the top within 6 months!! We are crushing it with them. Great marketing company to partner with. Through every step they have impressed me on how professional and knowledgable they are. I suggest you partner with them.

Hugo Vega Avatar
Hugo Vega
8/15/2019 - Google

BlackStorm is a real gem of a find. I had no idea all of the things my competitors were doing to grow and they broke it down for me and came up with a strategy for my company to grow as well. Happy customer

Jeannette Potter Avatar
Jeannette Potter
8/09/2019 - Google

Great job at seeing what my competitors were doing. We were able to shift and grow our campaign throughout the year and saw fantastic growth!

Larry Phelps Avatar
Larry Phelps
8/25/2019 - Google

They have done a phenomonal job with keyword research on my competitors and helping us to target their client. After only four months we have seen noticeable increase in sales. Cheer

Lisa Grant Avatar
Lisa Grant
7/19/2019 - Google

I have to say in the past I have been burned by marketing agencies and I was very skeptical in hiring another one but I knew I had to finally do something to stay in business. I found Black Storm because a friend highly recommended them so I decided to see what they could offer and to find out if they were just another scam. After working with them for 9 months I will say they have been very kind and professional in our dealings and they have actually exceeded my expectations on lead generation. I haven't experienced anything bad with them so if you're looking for a trustworthy marketing agency then I would suggest to give them a try.

How to Upload a File to Google Drive Through Google Sheets

I recently switched from our agency using Trello as our project management system to actually using Google Sheets instead and the transition as been amazing except one thing… We weren’t able to easily upload files directly to a task as we could with Trello. So I knew you could do a lot through app scripts in Google Sheets so I looked for a couple of solutions and yes the theory was proven in 2014 but the code was out of date and not working, so I had my developer updated the code and now it works flawlessly. Here are instructions if you want to have the capabilities of uploading a file directly to a google sheet and only display the Google Drive URL in the cell.

Here is a Google Sheet SAMPLE, just make a copy and edit.

 

Instructions

  • Go to > Tools > Script editor
    • Provide a name for the Script (we used Upload_Files)
    • Copy and paste the below code in the “Code.gs” file
      • NOTE: Be sure to insert your Google Drive folder id

Folder_Id = '1dsUl22eeCPSE7-Lpa7VGkR3Jx5TaLc5z'


function onOpen(e){
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var menuEntries = [];
  menuEntries.push({name: "File", functionName: "doGet"});
  ss.addMenu("Attach", menuEntries);
}


function upload(obj) {
  var file = DriveApp.getFolderById(Folder_Id).createFile(obj.upload);
  var activeSheet = SpreadsheetApp.getActiveSheet();
  var File_name = file.getName()
  var value = 'hyperlink("' + file.getUrl() + '";"' + File_name + '")'
  
  var activeSheet = SpreadsheetApp.getActiveSheet();
  var selection = activeSheet.getSelection();
  var cell = selection.getCurrentCell()
  cell.setFormula(value)
  
  return {
    fileId: file.getId(),
    mimeType: file.getMimeType(),
    fileName: file.getName(),
  };
}

function doGet(e) {
  var activeSheet = SpreadsheetApp.getActiveSheet();
  var selection = activeSheet.getSelection();
  var cell = selection.getCurrentCell();
  var html = HtmlService.createHtmlOutputFromFile('upload');
  SpreadsheetApp.getUi().showModalDialog(html, 'Upload File');
}

 

    • Still in the Script Editor click on File > New > HTML script
      • Insert the following code in that file between the two body tags

<!DOCTYPE html>
<html>
<head>
<base target="_top">
<link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons1.css">
</head>
<body>
<form> <!-- Modified -->
<div id="progress" ></div>
<input type="file" name="upload" id="file">
<input type="button" value="Submit" class="action" onclick="form_data(this.parentNode)" >
<input type="button" value="Close" onclick="google.script.host.close()" />
</form>
<script>
function form_data(obj){ // Modified
google.script.run.withSuccessHandler(closeIt).upload(obj);
};
function closeIt(e){ // Modified
console.log(e);
google.script.host.close();
};
</script>
</body>
</html>
  • Go back to your google sheet and refresh that page, then you should now see an “attach” button in the menu
    • Select a cell and hit attach and upload a file and watch the cell populate with a google drive attachment URL
advanced divider

ARE YOU READY TO DOUBLE YOUR LEADS AND SALES?

We work with roofers all over the country to uncover their problems, analyzing their competition, also developing a dominating growth strategy; we could easily charge $1,000.

We are offering this $1,000 strategy session completely Free. We will invest the time, resources, and expertise… all you have to do is invest your time.

Those who don’t take Step #1 can never take Step #2. Schedule your strategy session now.

advanced divider

Get the Plans to Your Home Services Business Growth & Live the Life of your Dreams..

If You Are Serious About Your Home Services Marketing, Click The Button Below To Schedule A Free 30-min Growth Strategy Session Today.