@surinderbhomra

Google Apps Script: Fetching Data From An External API

Jun 30, 2023 · 2 min read · While manually importing data into a Google Sheet to complete the boring chore of data restructuring, I wondered if there was any way that the initial import might be automated. After all, it would be much more efficient to link directly to an extern...

Integrate ActiveCampaign Into A Custom Form Using GatsbyJS/React

Sep 20, 2022 · 5 min read · ActiveCampaign is a comprehensive marketing tool that helps businesses automate their email marketing strategies and create targeted campaigns. If the tracking code is used, visitors can be tracked to understand how they interact with your content an...

Google Sheets: Copying Specific Cells To Another Sheet Using Google Apps Script

Jun 28, 2022 · 4 min read · Whenever there is a need to restructure an Excel spreadsheet to an acceptable form to be used for a SaaS platform or custom application, my first inclination is to build something in C# to get the spreadsheet into a form I require. This week I felt a...

Netlify Error: Gatsby requires Node.js xxx or higher

Jun 15, 2022 · 1 min read · I’ve recently updated my website (www.surinderbhomra.com) from the ground up and when it came to releasing all changes to Netlify, I was greeted by the following error in the build log: 7:39:29 PM: $ gatsby build 7:39:30 PM: error Gatsby requires Nod...

React: Using State Within An Arrow Function Component

May 28, 2022 · 2 min read · When building React applications, my components would consist of a mixture of React Function and Class components. As much as I love to use React Function components due to their simple, lightweight and concise code construction, I had a misconceptio...