| from BeautifulSoup import BeautifulSoup | |
| VALID_TAGS = [ | |
| 'div', | |
| 'span', | |
| 'a', | |
| 'p', | |
| 'br', |
| // Simple function to send Weekly Status Sheets to contacts listed on the "Contacts" sheet in the MPD. | |
| // Load a menu item called "Project Admin" with a submenu item called "Send Status" | |
| // Running this, sends the currently open sheet, as a PDF attachment | |
| function onOpen() { | |
| var submenu = [{name:"Send Status", functionName:"exportSomeSheets"}]; | |
| SpreadsheetApp.getActiveSpreadsheet().addMenu('Project Admin', submenu); | |
| } | |
| function exportSomeSheets() { |
| function testNewItemPost() { | |
| var request = { | |
| parameters: { | |
| token: "[]", | |
| user_name: "michelle", | |
| text: "add: Rural America; Hillbilly Elegy; J.D. Vance; From a former marine and Yale Law School graduate, a powerful account of growing up in a poor Rust Belt town that offers a broader, probing look at the struggles of America’s white working class; https://www.amazon.com/gp/product/0062300547/ref=pd_bxgy_14_2?ie=UTF8&pd_rd_i=0062300547&pd_rd_r=MG2AV2PZZVEXNYZ1Y84V&pd_rd_w=xCKNl&pd_rd_wg=55Iya&psc=1&refRID=MG2AV2PZZVEXNYZ1Y84V;" | |
| } | |
| }; | |
| doPost(request); | |
| } |
This is a script to export a CSV file from spreadsheet and make an user download it. When the users download it, they can download by push a button made by this script.
In order to use this script, put both HTML and script in a GAS project.
html :
This file name is "download.html".
| /* | |
| Copyright 2011 Martin Hawksey | |
| Licensed under the Apache License, Version 2.0 (the "License"); | |
| you may not use this file except in compliance with the License. | |
| You may obtain a copy of the License at | |
| http://www.apache.org/licenses/LICENSE-2.0 | |
| Unless required by applicable law or agreed to in writing, software |
| # -*- encoding: UTF-8 -*- | |
| import os | |
| import httplib2 | |
| # pip install --upgrade google-api-python-client | |
| from oauth2client.file import Storage | |
| from apiclient.discovery import build | |
| from oauth2client.client import OAuth2WebServerFlow |
| /** | |
| * Retrieves all the rows in the active spreadsheet that contain data and logs the | |
| * values for each row. | |
| * For more information on using the Spreadsheet API, see | |
| * https://developers.google.com/apps-script/service_spreadsheet | |
| */ | |
| function readRows() { | |
| var sheet = SpreadsheetApp.getActiveSheet(); | |
| var rows = sheet.getDataRange(); | |
| var numRows = rows.getNumRows(); |
| /** | |
| * A custom function that verifies an email ID | |
| * | |
| * @param {String} email ID | |
| * @return {Boolean} If the email ID is active | |
| * @customfunction | |
| */ | |
| function verifyEmail(email) { | |
| // Replace this with your Hunter.io API key |
Head over to developer.facebook.com and create an App
On your server, create a facebook webhook that will handle facebook calls. Then create a "leadgen" webhook on you App: https://developers.facebook.com/docs/graph-api/webhooks/v2.5
| <div style="font-family: sans-serif;"> | |
| <? var data = valid(); ?> | |
| <form id="form" name="form"> | |
| <? if(Object.prototype.toString.call(data) === '[object Array]') { ?> | |
| <? for (var i = 0; i < data.length; i++) { ?> | |
| <? for (var j = 0; j < data[i].length; j++) { ?> | |
| <input type="checkbox" id="ch<?= '' + i + j ?>" name="ch<?= '' + i + j ?>" value="<?= data[i][j] ?>"><?= data[i][j] ?><br> | |
| <? } ?> | |
| <? } ?> | |
| <? } else { ?> |