Want to use a google spreadsheet to fill in blogger post info.
$30-250 USD
Cerrado
Publicado hace casi 8 años
$30-250 USD
Pagado a la entrega
I want to use a Google spreadsheet to populate fields in a Blogger posts. Need someone to write the code and give me step by step instructions to get it up and running. Need to be available to walk me through if needed. This should be easy, most of the work has been done (see below). Uploaded image shows the Blogger post page with the fields I want to use.
This is what I have found online, but I can't seem to get it to work:
The Steps:
create spreadsheet in Google Drive or go to the spreadsheet created by your submission form
grab the docKey from the URL that looks like https://docs.google.com/spreadsheets/d/THE-KEY/edit#gid=0
use Row 1 in the spreadsheet to be the column headers that are used in the variables in the code. 1-word headers preferred for this example
go to File -> Publish to the Web, check "automatically republish when changes are made", and hit "start publishing"
The code example:
<script src='//[login to view URL]' type='text/javascript'/>
<script src='//[login to view URL]' type='text/javascript'/>
<script type='text/javascript'>//<![CDATA[
/**
this script was written by Confluent Forms LLC [login to view URL]
for the BlogXpertise website [login to view URL]
any updates to this script will be posted to BlogXpertise
please leave this message and give credit where credit is due!
**/
var docKey = '1Xg095tdG_9VY0b93FSh0eK52I2g6SjGg-g-pJ3u95YU'; // the docKey of your Google Docs spreadsheet
var insertAfter = '#Blog1'; // reference of object in your DOM to insert the object into
var objectType = '<div>'; // object that we'll be inserting as a container for the feed information
var objectID = 'thefeed'; // id of the object that is being inserted
var url = '[login to view URL]' + docKey +'/od6/public/values?alt=json';
$(document).ready(function(){
[login to view URL]('feeds', '1', { 'callback' : function(){
($.getJSON(url, 'callback=?')).success(function(data){
$(insertAfter).after(
$(objectType).attr('id',objectID)
);
var wrapper = $('#'+objectID);
$([login to view URL]).each(function(i,entry){
var name = [login to view URL]$name.$t;
var url = [login to view URL]$url.$t;
var type = [login to view URL]$type.$t;
var location = [login to view URL]$location.$t;
[login to view URL](
$('<ul>').append(
$('<li>').text(name)
).append(
$('<li>').text(url)
).append(
$('<li>').text(type)
).append(
$('<li>').text(location)
)
)
});
});
}});
});
//]]></script>
</head>
<body>
<div id='Blog1'>this won't be necessary in your actual implementation, placeholder for the Blog1 object</div>
</body>
</html>
Notes:
Please note that the first two lines will likely not be necessary in your template as they are likely already there. Add everything from <script type='text/javascript'>//<![CDATA[ to //]]></script> into your template, before </head>, to get it to work.
ID del proyecto: 11010782
Información sobre el proyecto
6 propuestas
Proyecto remoto
Activo hace 8 años
¿Buscas ganar dinero?
Beneficios de presentar ofertas en Freelancer
Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
6 freelancers están ofertando un promedio de $173 USD por este trabajo
3,5
3,5
2,5
2,5
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
Sobre este cliente
Cheverly, United States
0
Miembro desde abr 17, 2014
Verificación del cliente
Trabajos similares
$30-250 USD
₹12500-37500 INR
$30-250 CAD
$10-30 USD
₹1500-12500 INR
$250-750 USD
$30-50 SGD
$15-30 USD
$30-250 USD
$30-250 USD
$250-750 USD
₹12500-37500 INR
$30-250 USD
$15-25 USD / hour
$30-250 USD
$10-30 USD
$10-30 USD
$1000 USD
₹750-1250 INR / hour
₹600-1500 INR
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Falló el copiado al portapapeles. Intenta de nuevo después de ajustar tus permisos.
Copiado al portapapeles.
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.