Currently there is no any Add-on which offer this functionality, so you have to create or import custom functions by Script Editor available in Tools menu (for Spreadsheet). Then re-paste the content of ImportJSON.gs from bradjasper's GitHub page and save it.
After that, you can use ImportJSON function, for example:
This is not as straight forward as a normal import using the IMPORT function. With this function, you are able to perform imports only:
Adding a function, like SUM or FILTER, within the "range" string will result in an error. The solution must be found, by using the QUERY function:
I have had the same need for quite some time. And because I couldn't find anything suitable, I've built my own app.
It's called Calify. http://www.califyapp.com
The installer registers the app as the default program for handling *.ics files, so it works for both opening e-mail attachments and downloading event detail exports from webpages. It does not ...
Google is closing the service called Google Notebook. All documents are automatically imported from this service into Google Docs. If you don't remember using it don't worry about it. You can safely remove this document.
I based my solution to this off of the code to add Gmail as a mailto: handler, and adapted using information taken from Google Chrome's preferences file:
To use it, just go to Google Calendar, open Firefox's Web Console (Ctrl+...
If you are using Google Chrome then you can make Google Calendar your handler for ICS files:
Click the Chrome menu on the browser toolbar.
Select Settings → Show advanced settings (at the bottom of the screen)
In the Privacy section, click Content settings (you'll need to scroll down)
Click on Manage handlers... and associate webcal with "Google ...
draw.io online supports the legacy .vsd format and the .vsdx format, which is the default format from the 2013 and 2016 versions of the tool.
The actual process of importing to either drag and drop the .vsd(x) file into a diagram, use "File->Import From", or "File->Open From".
If you have issues with a .vsd(x) after you convert, please look at the draw.io ...
Most of the solutions I saw here were pretty technical. Here is one that is really easy to do. You could use this Zap to automatically create Trello Cards from Google Docs spreadsheet rows.
The idea is that once you make this Zap, you can paste your CSV into the a Google Doc and run it through into Trello.
I think there is a limit of about 200 items per 10 ...
If you press Ctrl+A, it will select all of the individual notes with its own interface. On the top, the yellow horizontal bar will become dark grey. The rightmost button of the center grouping is three vertical dots. If you click that, there's an option to Copy to Google Doc. Click that and there's a little dialog box that will soon give you a link that says ...
Here is the solution that I was able to use to resolve a similar need to import historical data as actual form responses.
the code first opens the form I created, and the spreadsheet with the historical data in the array named "values". The for loop cycles through each line of the spreadsheet, populating each item of the form, and then submitting each ...
The spreadsheet is not the actual repository of responses. There is a 'bucket' of responses that is connected to the form itself.
The data presentation features use the responses connected to the form.
You need to use a script to add the extra responses to the Form object. You won't be able to save the original dates with the old responses, as the ...
While it's possible to use files stored in Google Drive as website resources at this time it's not officially supported and should not be used for websites and spreadsheets that have a lifespan beyond August 31, 2016.
As was mentioned by AE I in his answer to a related question, the use of https://docs.google.com/uc?export=view&id=FILE_ID ...
Just announced from the Gmail team:
Easily add events from attachments in Gmail into Google Calendar
Now when you receive an attachment with calendar events in .ics format, you can add these events to your Google Calendar right from Gmail with just one click. No more downloading and manually importing!
Plus, events created in Google Calendar ...
I've created and shared a Google Spreadsheet which you can use to import multiple entries. It's geared towards a Scrum product backlog, but you could customise it if you want. Details here: http://www.littlebluemonkey.com/blog/online-scrum-tools-part-3-upload-existing-product-backlog-into-trello/
There is an official tool by the google liberation front to import and export google sites:
From the website: "The downloaded site will not be styled and will not include the chrome and is completely unstyled, but will contain all of the content included in the site."
I used @Jean-Francois answer together with Mogsdad to achieve my task: to merge data coming from many identical forms into just one. I added a skip for empty answers, as my form had many non required questions and jumping sections. To "upload" about 1000 responses with 30 items, I had to run twice the script because of timeout, just by changing initial row ...
See this: Blogger Help: Import and export blogs
To make a copy of your blog's posts and comments, you have to export your blog and then import it to another existing blog.
Export Your blog
To export your blog, simply click "Export Blog" from the Settings |
Then, click the Export Blog button. Your blog will be stored as a
Open the document
Go the File menu and select Make a copy...
Give the document a new name
You can optionally share it with the same people as the original
Comments are not copied
If you only have a link, because the author use the "Publish to the web..." tool, simply follow the link beneath the document to Google Drive, log in (if necessary), ...
I made a two lines script to use the share link of an image in Google Drive.
Go to Tools > Script editor.
Copy, paste the following code
Click on run for permission
prefix_url = "https://docs.google.com/uc?export=download&";
Using the script :
Copy the share link ...
If you set up an OAuth account, you can use the Google Sites API to automatically upload hundreds of web pages.
Had this same issue: This is what I ended up using.
=iferror(QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/[YOUR_KEY_FROM_URL]/edit","Title of Sheet You are Using!A2:I42"),"select * WHERE Col5 CONTAINS 'Towel'",1),"no values yet!")
Lets break it down a bit
IFERROR allows you to display a user friendly message if this fail because no data is ...
You'll need to make a spreadsheet.
Then go to tools>script editor.
You can cut/paste the script below replacing all of the contents that were put in by default.
You'll need to add your folder ID where it says THIS_SHOULD_BE_YOUR_FOLDER_ID (leave the quotes).
Hit the play/run button
You'll need to give it permission to run when asked.
That should ...
If the other calendar is shared with you and available in the "Other Calendars" section in Google Calendar, you can save the ICS version of the calendar and import that into your own.
To do this:
Go to Google Calendar Click the ellipsis to the right of the "other
calendar" that has all the events.
In the Integrate Calendar section, find ...
This is not currently possible. I have browsed the list of Chrome extensions and userscripts and there isn't anything that accomplishes your task. Best to wait for the API to reach read state.
Also popular social networks do not handle their import this way. Mass subscription sounds like something Google would try to prevent in the same way Twitter prevents ...
I'm not sure why you want to keep this content separately from the rest of the blog. Blogger has been supporting non-blog pages for several years now. If you want your content to be displayed on every page, you can add a widget with that content.
If you, after all, still want the content to be hosted externally, Blogger supports <iframe /> tag at ...
If you follow these steps, then you will get the job done:
go to Google Calendar settings
go to 'calendar'
import the .ics file
now tick the sync option under 'email account management' on your blackberry
Here is my suggestion for the script as I used for my project. I have modified the script by Tom to adjust when fields have different types of data (and in my case Section Headers where we should not do anything for). I used a "switch" and a "asTypeItem" to do the trick but if anybody got a better suggestion, I'm all ears!
We can also easily adapt the ...