Use Technology Save Time | Google Workspace

Google Apps Script for Auto Payment Reminder

If you want to automatically send payment reminders on the due date using Google Apps Script, here's how you can do it. Apps Script runs on Google Sheets, so the reminder details (name, email, due date, amount) will be stored in a Google Sheet.

Steps to Set Up:

1. Create a Google Sheet with the following headers in row 1:
A: Select Reminder YES/NO
B: Company Name
C: Name
D: Email Address
E: Email CC
F: Invoice Details
G: Total Amount
H: Due Date (format: DD-MM-YYYY)
I: Outstanding Days
J: Ledger
2. Open Apps Script in Google Sheets:
Click Extensions > Apps Script.
Delete any existing code and paste the following script.

Google Apps Script for Auto Payment Reminder

/* Copyright © Use Technology Save Time 
   This software is specially developed by UTST for Followers
   Unauthorized use & copying of this software will attract penalties. 
   For support contact usetechnologysavetime@gmail.com/https://virendertech.blogspot.com/
*/

function setupTrigger() {
  // Remove all existing triggers
  ScriptApp.getProjectTriggers().forEach(trigger => ScriptApp.deleteTrigger(trigger));

const template = SpreadsheetApp.getActive().getSheetByName("Template");
  const hour = template.getRange("B5").getValue();
  const day = template.getRange("B6").getValue().toUpperCase();

const weekdays = {
    MON: ScriptApp.WeekDay.MONDAY,
    TUE: ScriptApp.WeekDay.TUESDAY,
    WED: ScriptApp.WeekDay.WEDNESDAY,
    THU: ScriptApp.WeekDay.THURSDAY,
    FRI: ScriptApp.WeekDay.FRIDAY,
    SAT: ScriptApp.WeekDay.SATURDAY,
    SUN: ScriptApp.WeekDay.SUNDAY,
  };

function deleteTrigger() {
  const template = SpreadsheetApp.getActive().getSheetByName("Template");
  const triggers = ScriptApp.getProjectTriggers();
  
  if (triggers.length === 0) {
    Browser.msgBox("No Triggers are active");
    return;
  }

triggers.forEach(trigger => ScriptApp.deleteTrigger(trigger));
  template.getRange("B7").setValue("No Triggers are active");
  Browser.msgBox("All Triggers have been deleted!");
}

function sendEmails() {
  const ss = SpreadsheetApp.getActive();
  const dataSheet = ss.getSheets()[0];
  const templateSheet = ss.getSheetByName("Template");

const emailTemplate = templateSheet.getRange("B1").getValue();
  const emailSubject = templateSheet.getRange("B3").getValue();
  const bccRecipient = templateSheet.getRange("B4").getValue();
  const firstUse = dataSheet.getRange("Z1").getValue();

const today = Utilities.formatDate(new Date(), "GMT+5:30", "dd-MMM-YY HH:mm");
  const dataRange = dataSheet.getRange(2, 1, dataSheet.getMaxRows() - 1, 11);
  const rows = getRowsData(dataSheet, dataRange);

for (let i = 0; i < rows.length; i++) {
    const row = rows[i];
    if (row.select === "x") {
      const body = fillInTemplateFromObject(emailTemplate, row);
      GmailApp.sendEmail(row.emailAddress, emailSubject, body, {
        cc: row.emailcc,
        bcc: bccRecipient
      });

dataSheet.getRange(i + 2, 4).setComment(`Sent reminder on ${today}`);
      if (firstUse !== "1") {
    
      }
    }
  }
}

// ========== Utility Functions ==========

function fillInTemplateFromObject(template, data) {
  const vars = template.match(/\$\{\"[^\"]+\"\}/g) || [];
  let result = template;

vars.forEach(varStr => {
    const key = normalizeHeader(varStr);
    result = result.replace(varStr, data[key] || "");
  });

return result;
}

function getRowsData(sheet, range, headersRowIndex) {
  headersRowIndex = headersRowIndex || range.getRow() - 1;
  const numCols = range.getLastColumn() - range.getColumn() + 1;
  const headers = sheet.getRange(headersRowIndex, range.getColumn(), 1, numCols).getValues()[0];
  const data = range.getValues();
  return getObjects(data, normalizeHeaders(headers));
}

function normalizeHeaders(headers) {
  return headers.map(h => normalizeHeader(h)).filter(h => h.length > 0);
}

function isCellEmpty(cell) {
  return typeof cell === "string" && cell.trim() === "";
}

function isAlnum(ch) {
  return /^[a-z0-9]$/i.test(ch);
}

function isDigit(ch) {
  return /^[0-9]$/.test(ch);
}

How It Works:

1. Checks the Google Sheet for due dates matching today’s date.
2. Sends an email reminder using MailApp.sendEmail().
3. Updates the status to "Sent" to prevent duplicate emails.

Automate with Triggers

To automate the script:

1. Go to Apps Script > Triggers (Clock Icon)
2. Click "Add Trigger"
3. Select sendPaymentReminders
4. Choose:

Event Source: Time-driven
Type: Day timer (Once per day)

Now, reminders will automatically be sent on due dates! 🎉

Demo Sheet Download >

How to Add "Copy to Clipboard" in Blogger

Leave a Reply

How to Add "Copy to Clipboard" in Blogger

Step 1: Open the Blog Post

Open the blog post where you want to add the copy-to-clipboard feature.
Provide the blog post link in the video description.

Add JavaScript (JS) Code

Copy the provided JavaScript (JS) code.
Go to your Blogger Dashboard.
Click on Theme → Customize → Edit HTML.
Click anywhere in the theme code area.
Press Ctrl + F on your keyboard to open the search box.
Type </head> and press Enter.
Locate the </head> tag and paste the copied JS code right above it.
Click Save.

Step 2: Add the Script Code

Copy the provided script code from the post.
Go to your Edit Template page.
Click anywhere in the theme code area.
Press Ctrl + F and search for </body>.
Locate the </body> tag and paste the script code above it.
Click Save.

Step 3: Add the CSS Code

Copy the provided CSS code from the post.
Go to your Blogger Dashboard.
Click on Layout → Theme Designer → Advanced.
Select "Add CSS" from the dropdown menu.
Paste the copied CSS code.
Click Save.

Step 4: Add Copy-to-Clipboard HTML Code

Copy the HTML code from the post.
Go to your Blogger Post Editor.
Switch to HTML view.
Paste the copied HTML code where you want the copy-to-clipboard button.

Step 6: Customize the Clipboard Content

Locate the text/code placeholder in the HTML code.
Replace it with your own text or code that you want users to copy.

Step 7: Add a Unique Clipboard Tag

Find the clipboard tag in the HTML code.
Replace it with a unique tag (each copy-to-clipboard box should have a different tag).
Ensure that both the input ID and button reference have the same unique tag.

Step 8: Adjust Clipboard Height (Optional)

Modify the rows number in the textarea code to increase or decrease clipboard height.

Step 9: Update & Test

Click Update Post to save changes.
Open the post and test the copy-to-clipboard button.
Verify that it works correctly and is responsive on all devices.

🎉 Done! You have successfully added a Copy to Clipboard feature to Blogger! 🚀

1. Copy This JS Code and Paste it Above close Head Tag in Blogger Theme file

2. Copy This script Code and Paste it Above close Body Tag in Blogger Theme file

3. Copy This CSS and Paste it in Blogger Theme file Go to: Blogger Dashboard -> Layout -> Theme Designer -> Advanced -> Add CSS

/*-------Click-to-copy-------*/
    .copyarea {
        display: flex;
        position: relative;
        width: 100%;
        height: auto;
    }
    
    
    .copyarea textarea {
        width: 100%;
        box-sizing: border-box;
        border: none;
        padding-top: 34px;
        padding-bottom: 34px;
        padding-right: 11px;
        padding-left: 11px;
        background: #f5f6f7;
    }
    
    
    .copyarea textarea:focus-visible {
        outline: -webkit-focus-ring-color auto 0px;
    }
    
    
    button.ClickToCopyButton {
       width: 30%;
       height: auto;
       position: absolute;
       top: 0;
       right: 0;
       border: none;
       padding-top: 5px;
       padding-bottom: 5px;
       color: #fff;    
       background: #0066ff;
    }
    
    
    button.ClickToCopyButton:hover {
       background: #000;
    }
    
    
    @media screen and (max-width: 500px)
         {button.ClickToCopyButton {
              width: 100%;
    }}
    
    
    /*----xx------------Click-to-copy-------------xxxx---*/

4. Copy This Code and Paste it in Your Post You Must Give Unique Tag for Every Different Copy to Clipboard

Remove @ sign from Following code and Add (Left-Pointing Angle Bracket Symbol)

Apps Script Data Sorting

Script for Data Sorting

Leave a Reply

📌 Steps to Sort Data Using a Script in Google Sheets

Open your Google Sheet.

Click Extensions → Apps Script.

Delete any existing code and paste the script below.

Click Save (💾 icon).

Click Run ▶️ to execute the script.

🔹 Sorting a Specific Range

If you only want to sort a specific range (e.g., A:K by Column A)

✅ Modifications:
Change {column: 1, ascending: true} to sort by a different column.
Set ascending: false for descending order.

🔹 Auto-Sort When Data Changes

To automatically sort the sheet whenever the data changes, use this onEdit trigger:

✅ How to Enable Auto-Sorting: Go to Apps Script. Click Triggers (Clock Icon). Select onEdit and set it to run on "From spreadsheet → On edit".

🎯 Use Cases

✔️ Sort names alphabetically.

✔️ Arrange numbers from smallest to largest.

✔️ Automatically sort when data updates.

outstanding payment reminder overdue payment reminder Payment reminder payment reminder email payment reminder email to client payment reminder mail payment reminder message

Auto Send Payment Reminder On Due Date

Leave a Reply

Google Sheets में Auto Payment Reminder कैसे Setup करें without script ?

सबसे पहले एक Google Sheet Create करेंगे उसके बाद Sheets में Payment Data Create करेंगे।

Outstanding Days और Reminder Sent वाले Column में Arrayformula Enter करेंगे।

Outstanding Days Formula: =ARRAYFORMULA(if(Row(A:A)=1,"Outstanding Days",if(I:I="","", today()-I:I)))

Reminder Send Formula: =ARRAYFORMULA(if(Row(A1:A3)=1,"ReminderSent",if(J1:J3>=0, "Yes","No")))

सबसे पहले Extensions पर क्लिक करेंगे उसके बाद Add-ons पर क्लिक करेंगे ।

उसके बाद Search apps में Form Mule - Email Merge Utility search करेंगे और Install पर क्लिक करेंगे।

उसके बाद Extensions पर क्लिक करेंगे उसके बाद Form Mule - Email Merge Utility उसके बाद Setup उसके बाद Choose source data and set merge type पर क्लिक करेंगे।

Select sheet पर क्लिक करेंगे और data sheet को select करेंगे उसके बाद Next: Templates and send conditions पर क्लिक करते एक New Sheet create हो जाएगी जो की Hide होगी आप उसे Unhide भी कर सकते है।

Importance

मुझे आशा है कि मेरे द्वारा दी गई पूरी जानकारी Auto send Payment Reminder हिंदी में के बारे में अब आप अच्छे से समझ गए होंगे यदि आपके पास इस आर्टिकल के बारे में कोई भी Doubts हो तो आप मुझे नीचे अपनी टिप्पणी लिखें में सूचित कर सकते हैं यदि आपको मेरा यह आर्टिकल पसंद आया हो तो आप इसे सोशल नेटवर्क पर शेयर कीजिए।

Delegated How to add another email address How to add forwarding email address How to create group in gmail How to enable reading pane How to use confidential mode How to use vacation responder

Gmail Advanced Setting

Leave a Reply

How to Use Confidential Mode in Gmail?

Confidential Mode in Gmail allows you to send emails that protect sensitive information by setting an expiration date, restricting forwarding, copying, downloading, or printing, and even adding a passcode.

Step-by-Step Guide to Use Confidential Mode in Gmail:

Open Gmail and click on "Compose" to create a new email.
In the email window, look for the lock-and-clock icon (🕒🔒) at the bottom — this is the Confidential Mode button. Click on it.
A pop-up will appear. Here, you can:
- Set an expiration time (e.g., 1 day, 1 week, 1 month, etc.)
- Choose passcode protection:
  - No SMS passcode: Recipient can open it with Gmail directly.
  - SMS passcode: Recipient receives a passcode via SMS (you must enter their phone number).
Click "Save" after setting your preferences.
Compose your email as usual and click "Send".

🔐 The recipient won’t be able to forward, copy, print, or download the email contents.
⏳ Once expired, the content will no longer be viewable.

How to Change Your Gmail Password?

Here are the step-by-step instructions to change your Gmail (Google Account) password:

Step 1: Sign in to Your Google Account

Go to https://myaccount.google.com
Sign in using your Gmail ID and current password.

Step 2: Go to Security Settings

From the left-hand menu, click on “Security.”

Step 3: Find the "Signing in to Google" Section

Under the “Signing in to Google” section, click on “Password.”

Step 4: Verify Your Identity

You will be asked to re-enter your current password to verify it's you.

Step 5: Enter a New Password

Type your new password and confirm it by typing it again.
Make sure it's strong, using a combination of letters, numbers, and symbols.

Step 6: Save Your New Password

Click “Change Password” to confirm.

🔐 Note:

Make sure to remember your new password.
You will be signed out from other devices after changing your password.

How to enable the Reading Pane in Gmail and preview messages?

Step-by-Step Guide:

1. Open Gmail and sign in to your account.
2. Click the gear icon (⚙️) at the top right to open Quick Settings.

3. Under “Reading pane”, select one of the options:

No split – Default view (no reading pane)
Right of inbox – Preview opens on the right side
Below inbox – Preview opens at the bottom

4. After selecting your preferred option, Gmail will automatically update to show the reading pane.
5. Click any email to preview it in the pane without fully opening it.

When and How to Use the Vacation Responder in Gmail?

When to Use the Vacation Responder:

Use Gmail’s Vacation Responder feature when:

You're on vacation or leave and won't be checking emails.
You’re temporarily unavailable to respond to emails.
You want to inform senders of your absence and provide alternate contact information.

🛠️ How to Set Up Vacation Responder in Gmail:

Step-by-Step Guide:

1. Open Gmail

Go to https://mail.google.com and log in to your account.

2. Go to Settings

Click the gear icon (⚙️) at the top-right corner, then click "See all settings."

3. Scroll to “Vacation Responder”

In the “General” tab, scroll down to the "Vacation responder" section.

4. Enable Vacation Responder

Select “Vacation responder on.”

5. Set the Date Range

Choose the first day and last day for the auto-reply.
You can leave the end date blank if you're unsure.

6. Write Your Auto-Reply Message

Fill in:

Subject (e.g., "Out of Office")
Message (e.g., “Thank you for your email. I’m currently out of the office…”)

7. Optional: Send only to contacts

Check the box “Only send a response to people in my Contacts” if needed.

8. Click “Save Changes”

Your vacation responder is now active.

How to Create a Group in Gmail?

Creating a group in Gmail allows you to send emails to multiple people at once without typing each email address individually.

Step-by-Step Guide to Create a Group in Gmail:

Step 1: Go to Google Contacts

Open https://contacts.google.com in your browser.
Make sure you're logged in with your Gmail account.

Step 2: Select Contacts

Check the boxes next to the contacts you want to add to a group.

Step 3: Click on the “Label” Icon

At the top of the page, click the label icon (looks like a tag 🏷️).
Click “Create label” to make a new group.

Step 4: Name Your Group

Enter a name for your group (e.g., "Team Members", "Family", "Clients") and click Save.

Step 5: Add Contacts to Existing Group

To add more people later, select their names, click the label icon again, and choose the group name.

📩 How to Use This Group in Gmail

Open Gmail and click Compose.
In the To field, type the name of your label/group.
Gmail will automatically fill in all the email addresses from that group.

How to Grant Access to Your Gmail Account (Gmail Delegation)?

Step-by-Step Guide to Grant Gmail Access:

Step 1: Open Gmail

Go to https://mail.google.com and log into the account you want to delegate.

Step 2: Go to Settings

Click the gear icon in the top right corner.
Select "See all settings."

Step 3: Open the "Accounts and Import" Tab

Click on the “Accounts and Import” tab.

Step 4: Grant Access to Another Account

Scroll to “Grant access to your account.”
Click “Add another account.”

Step 5: Enter Email Address

Type the Gmail address of the person you want to give access to.
Click “Next Step” and then “Send email to grant access.”

Step 6: Access Approval

The person you invited will receive an email with a link.
They must click the link to confirm access.

📝 Note:

Delegates cannot change your password or chat on your behalf.
You can remove access anytime from the same settings panel.

How to Add a Forwarding Email Address in Gmail?

1. Open Gmail:

Go to https://mail.google.com and sign in to your Gmail account.

2. Go to Settings:

Click the Gear icon in the top-right corner.
Select “See all settings” from the dropdown.

3. Navigate to Forwarding and POP/IMAP tab:

In the settings menu, click on the “Forwarding and POP/IMAP” tab.

4. Add a Forwarding Address:

Click on “Add a forwarding address”.
Enter the email address you want to forward your emails to.
Click Next, then Proceed to confirm.

5. Verify the Forwarding Address:

A verification code will be sent to the email address you entered.
Open that email and click the confirmation link or enter the code back in your Gmail settings.

6. Enable Forwarding (optional):

Once verified, go back to the “Forwarding and POP/IMAP” tab.
Choose “Forward a copy of incoming mail to” and select the newly added address.
You can also choose what happens to Gmail’s copy (keep, archive, delete, etc.).

7. Save Changes:

Scroll down and click “Save Changes.”

How to Add Another Email Address in Gmail?

🔧 Step-by-Step Instructions:

1. Open Gmail Settings:

Log in to your Gmail account.
Click the gear icon (⚙️) in the top-right corner.
Select “See all settings.”

2. Go to 'Accounts and Import' Tab:

Click on the “Accounts and Import” tab.

3. Add Another Email Address:

Under “Send mail as,” click “Add another email address.”

4. Enter Email Details:

A pop-up window will appear.
Enter the name you want to display and the email address you want to add.
Click “Next Step.”

5. SMTP Configuration:

Enter the SMTP server settings of the other email provider (e.g., smtp.mail.yahoo.com for Yahoo).
Provide the username and password of that email account.
Click “Add Account.”

6. Verify the Email:

Gmail will send a verification code to the other email address.
Enter the verification code or click the link in the email to confirm.

✅ After Setup:

You can now choose which email address to send from when composing a new message in Gmail (use the “From” field dropdown).

How to Save a Template in Gmail ?

1. Open Gmail:

Go to https://mail.google.com and log in to your account.

2. Enable Templates Feature:

Click the Gear icon in the top-right corner and select “See all settings.”
Go to the “Advanced” tab.
Find “Templates” and click “Enable.”
Scroll down and click “Save Changes.”

3. Create a Template:

Click “Compose” to open a new email window.
Type the email content you want to save as a template.

4. Save the Template:

Click the three vertical dots (More options) in the bottom-right of the compose window.
Hover over “Templates” > then click “Save draft as template” > “Save as new template.”
Enter a name for the template and click Save.

5. Use the Template Later:

When composing a new email, click the three dots again.
Hover over “Templates” and select your saved template to insert it into the message.

Importance

I hope that you have now clearly understood all the information I provided about Gmail Advanced Settings. If you have any doubts or questions regarding this article, please feel free to let me know by writing your comment below. If you liked this article, please share it on social media.

How to check history How to lock editor access permissions and share of other users How to lock rang and sheet How to lock viewers and commenter of copy and download How to share google sheets

Google Sheets Advanced

Leave a Reply

How to share a Google Sheet with others and give access permissions so that multiple users can work on it at the same time?

✅ Steps to Share a Google Sheet with Others:

1. Open Google Sheets

Go to https://sheets.google.com and open the sheet you want to share.

2. Click the "Share" Button

In the top-right corner, click the blue "Share" button.

3. Enter Email Addresses

In the “Share with people and groups” box, type the email addresses of the people you want to share with.

4. Set Permissions

Click the dropdown next to each email address and choose:

Viewer – can only view
Commenter – can view and comment
Editor – can edit and work on the sheet

5. (Optional) Add a Message

You can write a message to notify them about the sheet.
6. Click "Send"
After setting permissions, click Send to share the sheet.

✅ To Allow Anyone with the Link to Access:

Click "Share"
At the bottom, click “Anyone with the link”
Change the permission (Viewer, Commenter, Editor)
Click “Copy link” and share it

✅ Now Multiple Users Can Work Together:

When shared as Editor, all users can work on the sheet at the same time.
You can see who else is working live via their profile icons on the top-right.

How to Prevent Editors from Sharing or Changing Access Permissions?

Step 1: Open Your Google Sheet

Go to https://sheets.google.com and open your shared sheet.

Step 2: Click the “Share” Button

Located in the top-right corner.

Step 3: Click the ⚙️ Gear Icon (Settings)

In the sharing dialog, find and click the gear icon in the top-right of the popup.

Step 4: Disable Editor Permissions

Uncheck both options:
- ✅ Editors can change permissions
- ✅ Viewers and commenters can see the option to download, print, and copy

This ensures that only the owner can share or modify access.

Step 5: Click “Done” to Save Settings

🔒 Result:

Now, editors can still edit the content of the sheet, but:

They cannot change share settings
They cannot invite others
They cannot remove others
They cannot transfer ownership

How to See Who Made Changes in Google Sheets?

To track changes made by an Editor in Google Sheets, you can use the built-in Version History feature.

Step-by-Step Guide:

1. Open your Google Sheet
2. Click on File in the top menu
3. Select Version history → then click “See version history”

4. On the right side, you’ll see:

A list of timestamps
The names of editors who made changes

5. Click any version to:

Highlight changes
See what was added, removed, or edited

6. (Optional) Click “Restore this version” to go back to that state

🔄 Shortcut:

You can also press:
Ctrl + Alt + Shift + H (on Windows)
Cmd + Option + Shift + H (on Mac)

🧠 Tip:

You must have edit access or be the owner to view version history.
Google Sheets automatically tracks all changes.

How to open and use the Explore feature in Google Sheets?

✅ How to Open the Explore Tool in Google Sheets

1. Open your Google Sheet where you want to use Explore.

2. At the bottom-right corner of the screen, you’ll see a small star-shaped icon or the word “Explore”.

3. Click on “Explore”.

🛠️ How to Use the Explore Tool

Once open, Explore offers several powerful features:

1. Automatic Analysis

Explore automatically analyzes your data and shows:
- Quick insights
- Trends
- Summaries (like totals, averages, etc.)

2. Ask Questions in Natural Language

You can type a question like:
- “What is the total sales?”
- “Average of column B?”
Google Sheets will give you answers instantly with formulas or charts.

3. Suggested Charts

It suggests graphs and charts based on your data.
Click on a chart to insert it directly into your sheet.

4. Pivot Tables & Formatting Suggestions

Explore may also suggest pivot tables for deeper analysis.
You may see formatting suggestions to make your data more readable.

💡 Tip:

If Explore is not visible, make sure you have some data selected or added to your sheet. It works best with organized tables or numerical data.

How to lock a range or entire sheet in Google Sheets?

✅ To Lock a Range (Specific Cells)

1. Select the range of cells you want to lock (e.g., A1:C10).

2. Right-click on the selected cells and click “Protect range…”

OR go to the menu: Data > Protect sheets and ranges

3. A sidebar will appear on the right. Add a description (optional), then click “Set permissions.”

4. In the “Range editing permissions”:

Choose “Only you” if you want to lock it for everyone else.
Or select “Custom” to allow specific people to edit.

5. Click Done.

✅ To Lock the Entire Sheet

1. Click on the sheet tab (bottom-left) you want to protect.
2. Go to Data > Protect sheets and ranges.
3. In the sidebar, select the “Sheet” tab.
4. Choose the correct sheet from the dropdown if needed.

5. Click “Set permissions”, then choose:

Only you
Or select specific people who can edit.

7. Click Done.

⚠️ Important Notes:

Locking doesn’t stop others from viewing the sheet—only editing.
To fully restrict access, change the sharing settings from File > Share.

How to make a duplicate copy of a Google Sheet or share it with another user?

✅ How to Make a Duplicate (Copy) of a Google Sheet

1. Open the Google Sheet you want to copy.
2. Click on File > Make a copy.

3. A dialog box will appear:

Give the copy a new name.
Choose the folder/location in Google Drive.

4. Click OK.

✅ This creates a new, separate file that you own and can edit freely.

✅ How to Share a Google Sheet with Another User

1. Open the Google Sheet.

2. Click the “Share” button in the top-right corner.

3. Enter the email address of the person you want to share with.

4. Choose their permission level:

Viewer – Can only view
Commenter – Can comment
Editor – Can edit

5. (Optional) Add a message.

6. Click Send.

🔐 Tip:

If you want to share a view-only copy, but allow them to make their own version:

Share as Viewer, and tell them to go to File > Make a copy.

✅ Steps to Create a “Copy” Link for Google Sheets

1. Open your Google Sheet.
2. Click the “Share” button (top-right).

3. Under “General access”, change to:

Anyone with the link
Set permission to Viewer (so they can’t edit your original).

4. Click Copy link.

✏️ Now Modify the Link

The link will look like this:

Before:- https://docs.google.com/spreadsheets/d/1mT62Ut_rpRY/edit?usp=sharing

After:- https://docs.google.com/spreadsheets/d/1mT62Ut_rpRY/copy

Before:- https://docs.google.com/spreadsheets/d/1mT62Ut_rpRY/edit?usp=sharing

After:- https://docs.google.com/spreadsheets/d/1mT62Ut_rpRY/template/preview

How to set Notification Rules in Google Sheets so that you get a notification when someone edits a shared sheet?

✅ Steps to Set Notification Rules in Google Sheets

1. Open the Google Sheet

Go to Google Sheets and open the sheet you’ve shared with others.

2. Click on the “Tools” menu

At the top menu bar, click on Tools.

3. Select “Notification rules”

In the dropdown, click on Notification rules…

4. Choose when to receive notifications

You’ll see two main options:

“Any changes are made” – You’ll be notified whenever someone edits the sheet.
“A user submits a form” – Only for Sheets linked to Google Forms.

5. Choose how often to receive notifications

Email – right away (you get an immediate email after each change)
Daily digest (you get one email per day with a summary of all changes)

6. Click “Save” After setting your preference, click Save and then Done.

📬 Example Notification Email

You’ll receive an email with details like:

"Change made to your spreadsheet
User John Doe edited cell B3 on June 14 at 3:12 PM."

How to Use Publish to the Web in Google Sheets?

1. Open your Google Sheet
Go to Google Sheets and open the desired file.
2. Click on “File” in the top menu
3. Select “Share” → Click on “Publish to the web”

4. Choose what you want to publish

Entire Document or a specific sheet
Optionally, choose Web page or CSV, PDF, etc.

5. Click “Publish”
Confirm by clicking OK when prompted.

6. Copy the public link or embed code

You can share this link or
Click on Embed to get HTML code for websites.

📌 Notes:

Changes you make to the sheet will be reflected automatically in the published version.
Viewers cannot edit the published version.
You can stop publishing anytime.

What is “Create New Filter View” in Google Sheets?

"Create New Filter View" is a feature in Google Sheets that lets you filter and sort data in a spreadsheet without affecting what others see. It’s useful when you're collaborating and want to temporarily look at data in a certain way without disrupting others.

📌 When to Use Filter View:

You want to sort/filter data only for yourself (not all users)
You're working on shared spreadsheets
You want to save custom filtered views to come back to later
You need to analyze specific rows/columns without changing the master data

✅ How to Use Create New Filter View (Step-by-Step):

1. Open your Google Sheet
2. Click on “Data” in the top menu
3. Select “Filter Views” → Click “Create new filter view”

4. A black border will appear around your data.
Now you can:

Click on filter icons in the column headers
Apply filters (e.g., sort A–Z, show only values > 100)

5. Name your filter view (top-left corner)
6. When done, just close the filter view tab (it will be saved automatically)
7. You can return to it anytime via:
Data > Filter views > [Your Saved Filter View Name]

Importance
I hope that you have now clearly understood all the information I provided about Google Sheets Advanced. If you have any doubts about this article, feel free to let me know by leaving a comment below. If you liked this article, please share it on your social networks.

Google Apps Script for Auto Payment Reminder

Steps to Set Up:

Google Apps Script for Auto Payment Reminder

How It Works:

Automate with Triggers

How to Add "Copy to Clipboard" in Blogger

How to Add "Copy to Clipboard" in Blogger

Step 1: Open the Blog Post

Add JavaScript (JS) Code

Step 2: Add the Script Code

Step 3: Add the CSS Code

Step 4: Add Copy-to-Clipboard HTML Code

Step 6: Customize the Clipboard Content

Step 7: Add a Unique Clipboard Tag

Step 8: Adjust Clipboard Height (Optional)

Step 9: Update & Test

Script for Data Sorting

📌 Steps to Sort Data Using a Script in Google Sheets

Open your Google Sheet. Click Extensions → Apps Script. Delete any existing code and paste the script below. Click Save (💾 icon). Click Run ▶️ to execute the script.

🔹 Sorting a Specific Range

🔹 Auto-Sort When Data Changes

Auto Send Payment Reminder On Due Date

Google Sheets में Auto Payment Reminder कैसे Setup करें without script ?

Gmail Advanced Setting

How to Use Confidential Mode in Gmail?

How to Change Your Gmail Password?

How to enable the Reading Pane in Gmail and preview messages?

When and How to Use the Vacation Responder in Gmail?

🛠️ How to Set Up Vacation Responder in Gmail:

How to Create a Group in Gmail?

📩 How to Use This Group in Gmail

How to Grant Access to Your Gmail Account (Gmail Delegation)?

How to Add a Forwarding Email Address in Gmail?

How to Add Another Email Address in Gmail?

✅ After Setup:

How to Save a Template in Gmail ?

Google Sheets Advanced

How to share a Google Sheet with others and give access permissions so that multiple users can work on it at the same time?

✅ Steps to Share a Google Sheet with Others:

✅ To Allow Anyone with the Link to Access:

✅ Now Multiple Users Can Work Together:

How to Prevent Editors from Sharing or Changing Access Permissions?

How to See Who Made Changes in Google Sheets?

Step-by-Step Guide:

🔄 Shortcut:

🧠 Tip:

How to open and use the Explore feature in Google Sheets?

✅ How to Open the Explore Tool in Google Sheets

🛠️ How to Use the Explore Tool

💡 Tip:

How to lock a range or entire sheet in Google Sheets?

✅ To Lock a Range (Specific Cells)

✅ To Lock the Entire Sheet

⚠️ Important Notes:

How to make a duplicate copy of a Google Sheet or share it with another user?

✅ How to Make a Duplicate (Copy) of a Google Sheet

✅ How to Share a Google Sheet with Another User

🔐 Tip:

✅ Steps to Create a “Copy” Link for Google Sheets

✏️ Now Modify the Link

How to set Notification Rules in Google Sheets so that you get a notification when someone edits a shared sheet?

✅ Steps to Set Notification Rules in Google Sheets

📬 Example Notification Email

How to Use Publish to the Web in Google Sheets?

📌 Notes:

What is “Create New Filter View” in Google Sheets?

📌 When to Use Filter View:

✅ How to Use Create New Filter View (Step-by-Step):

Popular Posts

Labels List

Facebook Page Like

Subscribe Us

Report Abuse

Open your Google Sheet.

Click Extensions → Apps Script.

Delete any existing code and paste the script below.

Click Save (💾 icon).

Click Run ▶️ to execute the script.