Blog

You can use Google Apps Script to retrieve data from Facebook Ads to Google Sheets:

integrate OpenAI with Google Sheets for FREE

Integration of OpenAI with Google Sheets can be easily done using Apps Script. From the Google Sheet, you will be able to pass custom prompts…

Read more

automatically add new Google Task items to Asana

It is possible to automatically add new Google task items to Asana using Google Apps Script. You can follow the below exact steps to achieve…

Read more

stream Google Analytics data to Bigquery

Google Analytics 4 is replacing universal analytics and as per Google, you can only find GA4 data for a maximum of 14 months. If you…

Read more

extract email addresses from Gmail

You can use the below Apps Script code to extract email addresses from Gmail label. This script searches for emails in the “INBOX” label and…

Read more

turn off Google form responses with certain conditions

To turn off Google form responses after a certain number of responses, you can use the below Apps Script code: To shut off the form…

Read more

restore Gmail data from Google Cloud Storage

In our previous post, we discussed about how you can archive Gmail data to Google Cloud storage. You could also do the reverse with Google…

Read more

How to backup Gmail data to Google Cloud storage bucket

You could backup Gmail data as an archive to Google Cloud storage. To do the export, you can use Apps Script. Below is a sample…

Read more

How to create a Jira ticket on Google form submision

Using Appsscript, you can create an integration to connect Jira and Google Form. To create a Jira ticket upon Google Form submission using Google Apps…

Read more

How to send emails with AWS Simple Email Service(SES) using Google Apps Script

You can use Google Apps Script to send emails through Amazon SES (Simple Email Service) by following these steps: // Load the AWS SDK for…

Read more

10/316