- Go to sheet file
- Extensions
- App Script
- Go to sheet file
- Clear cell
The status enabled can be cleared and only applies if header hero needs to be displayed
Facebook,fab fa-facebook fa-2x,https://www.yourlink.com, enabled
Instagram,fab fa-instagram fa-2x,https://www.yourlink.com, enabled
X,fa-brands fa-x-twitter fa-2x,https://www.yourlink.com, enabled
LinkedIn,fab fa-linkedin fa-2x,https://www.yourlink.com, enabled
GitHub,fab fa-github fa-2x,https://www.yourlink.com, enabled
Technical Details
``` function doGet() { // Get a reference to the active spreadsheet const doc = SpreadsheetApp.getActiveSpreadsheet(); console.log("Active Spreadsheet:", doc.getName()); // Log the active spreadsheet name// Get a reference to the sheet named "Social" const sheet = doc.getSheetByName("Social"); console.log("Sheet object:", sheet); // Log the sheet object itself
// Retrieve values from a range of cells: // - Starts at cell A1 (column 1, row 1) // - Includes 10 rows // - Includes 6 columns const values = sheet.getRange(1, 1, 10, 7).getDisplayValues(); console.log("Retrieved values:", values); // Log the retrieved 2D array of values
// Transform the 2D array of values into an array of objects: const result = values.map((s) => ({ name: s[0], icon: s[1], link: s[2], status: s[3], description: s[4], iconDescription: s[5], tagline: s[6], })); console.log("Transformed result:", result); // Log the final array of objects
// Create a JSON response containing the transformed data: return ContentService.createTextOutput(JSON.stringify({data: result})).setMimeType(ContentService.MimeType.JSON); }
More details here: https://developers.google.com/apps-script/guides/web
Change Log
04/04/2024 - Clear data03/04/2024 - Dynamically render page title
10/04/2024 - Update border
14/04/2024 - Update design, add tagline
18/04/2024 - Logo add, links update
03/07/2024 - Add row for new social link
18/07/2024 - Linkje add